Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “mistrals” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

185 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
mistrals10121262(None) 
mistral91013641mistral_
mistrials1148131mistrials
astrals75515242_astrals
australs8359532australs
citrals91111672ci_trals
minerals10311372minerals
minstrels1145692minstrels
misdeals1147222misdeals
misdials1137492misdials
misdraws1445752misdraws
miskals13369762mis_kals
missals93914422mis_sals
mistrace12312642mistrace
mistraces13312292mistraces
mistrain10311942mistrain
mistrains11511352mistrains
mistreats1148632mistreats
mistress10310702mistress
mistrial10311382mistrial_
mitral81314322mi_tral_
ristras7311562ristra_s
astral66919283_astral_
austral73411513austral_
australes9317763australes
bistres94017213bistr_es
bistros92810983bistr_os
centrals102712033centrals
cistrons102710623cistrons
citral81113893ci_tral_
coistrels1145263coistrels
coistrils1146423coistrils
costrels1038933costrels
diastral946993diastral_
dishrags1346203dishrags
dismals102010243dis_mals
distal73615773dist_al_
distills9319043distills
distils83015803dist_ils
distract11313023distract
distracts1249283distracts
distrain9412243distrain
distrains10411333distrains
distrait9414343distrait
distress9311713distress
dustrags1044943dustrags
estral64716513_estral_
estrays10529403_estrays
fiscals1238003fis_cals
fistfuls1454563fistfuls
fistulas1155403fistulas
gastral8329553gastral_
instals7611713inst_als
inthrals11258503_inthrals
kestrels1235813kestrels
kistfuls1553833kistfuls
liberals1039413liberals
listels74212433list_els
literals8312293literals
littorals944133littorals
lustral7339653lustral_
magistral1243623magistral_
mantrams12288963mantrams
mantraps12298063mantraps
mantras93815863mantra_s
matrass939403m_atrass
mattrass1045863mattrass
mescals112911563mes_cals
mestranols1243273mestranols
metals84520883m_et_als
midstreams1542573midstreams
mihrabs1444203mi_hrabs
mineral9312733mineral_
minimals12327433minimals
minstrel1046913minstrel_
minstrelsy1551673minstrelsy
misbias1139083misbia_s
misbills1246083misbills
misbrand1346413misbrand
misbrands1445153misbrands
miscall1139653mis_call
miscalls1239003miscalls
misclass1246843misclass
misdeal1037663misdeal_
misdealt1147983misdealt
misdial1039643misdial_
misdraw1345623misdra_w
misdrawn1444343misdrawn
miseats92815783mis_eats
misenrols1144253misenrols
miserable1349653miserable
miserables1445613miserables
miserably1646663miserably
miseries10320403miseries
miserly12329823miser_ly
misers85025703miser__s
misframe1546973misframe
misframes1646633misframes
misgrade1247503misgrade
misgrades1347363misgrades
misgraft1447203misgraft
misgrafts1544293misgrafts
misgrows1444963misgrows
mishaps1438723mis_haps
mishears1338323mishears
miskal123710263mis_kal_
mislays12349243mis_lays
misleads11358543misleads
mismarks1645893mismarks
misparts12108173misparts
misplans1238863misplans
misplays1555543misplays
misraise10410523mis_raise
misrate91319143mis_rate
misrates101318243mis_rates
misreads11268923misreads
misrely12319613mis_rely
misrule939353mis_rule
misrules1039383mis_rules
missal84314903mis_sal_
missays124010253mis_says
misseats104011683misseats
missels94614813mis_sels
misstarts1145833misstarts
mistake131312623mist_ake
mistakes141213413mistakes
mistbows1543993mistbows
misteach1545443misteach
mistends11419593mistends
misterms123711353misterms
misters93927513mist_ers
misthrows17114213misthrows
mistily122612343mist_ily
mistimes12612613mistimes
mistitle1038523mistitle
mistitles1147953mistitles
mistraced1439453mistraced
mistreat10313113mistreat
mistrust1049203mistrust
mistrusts1146013mistrusts
mistruth1346043mistruth
mistruths1443683mistruths
mistryst1345843mistryst
mistrysts1443863mistrysts
mists76633903mist___s
mistunes10311133mistunes
mistypes15116713mistypes
mitres83922073mi_tr_es
mitsvahs1642003mitsvahs
morals85324633m__orals
mortals93914003mort_als
murals84016763m__urals
musicals1247093musicals
muskrats1444313muskrats
mustards11297883mustards
mutuals937123m_utuals
neutrals846283neutrals
nitrils72810703ni_trils
nostrils848183nostrils
pastorals1147953pastorals
peytrals1355493peytrals
pistils93314303pist_ils
pistols93213983pist_ols
postals93716373post_als
restorals978073restorals
ristra6310713ristra__
rituals738353ri_tuals
rostral7311333rostral_
sisals63013573sis__als
sistra639333sistra__
sistrums1055313sistrums
steals64020063__steals
straps87721783__straps
strass67117223__strass
straws98718673__straws
strays96417933__strays
unstraps1045983unstraps
ventrals112910003ventrals
vestals104612333vest_als
vestral104111013vestral_
victuals1344773victuals
vistas94513273vist_a_s
visuals1036853vis_uals
vitals94514303vi_t_als
wastrels1136203wastrels

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.423422437.4
2DLD Change Limit1461621857.31319986.6
3Display Results1851850.0603083.3
 (SQL Overall)1786911857.79622920.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.