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 “miracles” 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.

158 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
miracles123833(None) 
miracle1138841miracle_
circles1139902cir_cles
coracles121811162coracles
macles107023222m__acles
manacles1239522manacles
mirages102213532mira_ges
morales93619402mora_les
oracles93212422_oracles
piracies12312642piracies
spiracles1345662spiracles
airholes1138033airholes
amirates101114793amira_tes
arables91814973_arables
auricles10138333auricles
barnacles1355333barnacles
bicycles1743883bicycles
bifaces1448063bifac_es
binnacles13244583binnacles
binocles1236413binocles
birches143412323bir_ches
birles84920643bir__les
boraces113716853borac_es
braces108427773_brac_es
braches144621223_braches
caracoles13310073caracoles
cenacles1238023cenacles
circle1039703cir_cle_
circled1237583cir_cled
circler1136423cir_cler
circlers1235343cir_clers
circlet11311473cir_clet
circlets1235663cir_clets
coracle112011723coracle_
crackles164111273_crackles
cradles103114123_cradles
curacies12311763curacies
debacles1335723debacles
disables11410903disables
durables11237013durables
earaches13411303earaches
embraces14128863embrac_es
emirates101214843emira_tes
fiacres1237253fi_acres
finagles12237553finagles
finales104016013fina_les
giraffes1542603giraffes
girasoles1083713girasoles
girdles92210003gir_dles
girolles935523girolles
graces94523493_grac_es
graciles112511613_graciles
grackles15309183_grackles
hirable121612313hirable_
hirples12149643hir_ples
hirsles101510073hir_sles
hyraces1537913hyrac_es
icicles1135943_icicles
impales113311763impa_les
irades74517393_ira_des
kirsches1743843kirsches
kirtles11309663kir_tles
maces97139963m__ac_es
maches134827233m__aches
mackles154415753m__ackles
macle96127003m__acle_
macled116718113m__acled
macules114015133m__acules
mailes84329113m__ailes
males75049793m__a_les
manacle11310283manacle_
manacled1336453manacled
maples104819423m__aples
maracas11313773marac_as
marbles114516653mar_bles
marcels113212373mar_cels
marches143921173mar_ches
measles92412753m_easles
menaces112715523menac_es
merces105720743mer_c_es
merches144013763mer_ches
mercies113817563mer_cies
merles85322763mer__les
miauled1036663mi_auled
miauls8178713mi_aul_s
micelles1288833micelles
miches134320733mi__ches
mickles153415003mi_ckles
middles113415303mi_ddles
midranges1344653midranges
midsoles1137763midsoles
miggles113512033mi_ggles
migraines1286923migraines
migrates111112843migra_tes
miladies1139913miladies
milages103114403mila_ges
miles74645073mi___les
milles84526563mi__lles
millraces1345753millrac_es
minable112315073minable_
minces104420803mi_nc_es
mingles103719003mi_ngles
mirabelles1443423mirabelles
miraculous1453093miraculous
miradors1146833miradors
mirage92313653mira_ge_
mires75640883mir___es
mirexes1636993mir_exes
mirthless1443353mirthless
misacted1338673misacted
misacts1139353misac_ts
misallies1148383misallies
miscalls1239003miscalls
miscues11312393mi_scues
miserables1445613miserables
misfiles133110983misfiles
misraises1149933misraises
misrates101318233misra_tes
misrules1039383misrules
missiles103015083missiles
mistraces13312283mistrac_es
mixable18259173mixable_
mizzles17329493mi_zzles
monocles12310673monocles
moraines10314343moraines
morale85220553mora_le_
morals85324633mora_l_s
morasses1038903morasses
morelles10710493morelles
movables15175573movables
muraled10410823mura_led
muralled1136413muralled
murals84016753mura_l_s
murices112612283muric_es
muscles11310563m_uscles
myrtles1235733myr_tles
oraches124216473_oraches
oracle84313293_oracle_
parables121613563parables
percales12313783percales
pinnacles13276043pinnacles
pinocles1248693pinocles
pirates93020323pira_tes
races74943243__rac_es
rales54947493__ra_les
silicles1037073silicles
smirches1535993smir_ches
spiracle1255803spiracle_
tirades8311723tira_des
traces85329933_trac_es
trachles13311753_trachles
treacles1039703treacles
utricles1037223utricles
vernacles1445073vernacles
viragoes1245233viragoes
virgules1244333virgules
vivaces1536413vivac_es
wirable121610963wirable_

Search took 10 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.1531167915.0
2DLD Change Limit1461621589.16015956.6
3Display Results1581580.0931698.9
 (SQL Overall)1786911589.40618997.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.