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

300 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
rancho11431085(None) 
ancho104515301_ancho
ranch105019791ranch_
ranchos123911391ranchos
anchor113911972_anchor
anchos114214892_anchos
banco94019392banc_o
branch134014772branch_
branchy17357912branchy
broncho14206462broncho
cancha134411612cancha
concho134414262concho
cranch133613532cranch_
gaucho1256222gaucho
honcho14389382honcho
macho126120152ma_cho
manche133515102manche
nacho105414382na_cho
poncho133310122poncho
rance75028512ranc_e
rances84625442rances
ranched133113602ranched
rancher123013632rancher
ranchero13277422ranchero
ranches123620112ranches
rancid9513862rancid
rancor8810372rancor
ratch104221362ratch_
raunch11358432raunch_
raunchy15284312raunchy
reecho11318652reecho
tranche123312222tranche
abmho1236793_abmho
ache96829823_a_che
achoo10315083_a_choo
achy126316093_a_chy
ahchoo1445713_ahchoo
altho86312603_altho
anchors123912953_anchors
anchovy1843953_anchovy
ancon75718233_ancon
andro6314163_andro
anglo65215373_anglo
ankh111114413_ankh_
ankhs12116723_ankhs
anyhow1544103_anyhow
arch98628443_arch_
archon11311753_archon
arco68331543_arc_o
bach116131393ba_ch_
bancos104713893bancos
banjo143812443ban_jo
batch124620103batch_
bench125619503bench_
blanch133410853blanch_
brach126123303bra_ch_
brachs134415753bra_chs
branched163210453branched
branches153613803branches
branchia15217713branchia
bronchi14176313bronchi
bronchos15206173bronchos
bronco10179493bronc_o
brunch13329353brunch_
bunch125118603bunch_
bunchy16437463bunchy
bunco94616083bunc_o
cacao95420003ca_cao
cache125122483ca_che
cachou13310623ca_chou
cancan10314103cancan
cancel105316683cancel
cancer104220923cancer
canchas143212403canchas
canso75019403can_so
canthi11310973canthi
canto74931013can_to
catch125120373catch_
catchy16559583catchy
cinch124516243cinch_
coanchor1545253coanchor
conch124620073conch_
concha134213283concha
conchos144313963conchos
conchs134714903conchs
conchy163710223conchy
cranched163210413cranched
cranches153114543cranches
cratch134110793cratch_
craunch1464443craunch_
crunch13349503crunch_
crunchy17324763crunchy
dacha114812573da_cha
dance85223133danc_e
danced105315253danced
dancer94817613dancer
dances95120653dances
danio6319783dan_io
datcha1266563datcha
drachm1436493dra_chm
drench12369593drench_
dunch115316263dunch_
each95530583ea_ch_
echo96615953__echo
fancy134615483fanc_y
fano75831693fan__o
finch135416973finch_
franc104615413franc__
francs114112193franc_s
french143511213french_
ganache1346213ganache
gauche1238553gauche
gauchos1345903gauchos
grinch1238483grinch_
hance105424153hanc_e
hances115621283hances
hatch135719593hatch_
haunch14377343haunch_
honchos15369573honchos
hunch136416213hunch_
inch95420823_inch_
junco144612203junc_o
kench145513923kench_
laich105920713laich_
laichs115110893laichs
lance75126723lanc_e
lanced93717723lanced
lancer84319973lancer
lances84824103lances
lancet84223573lancet
lanugo735573lanugo
larch105919793larch_
latch104620463latch_
launch11368063launch_
lunch104917243lunch_
lynch13468983lynch_
mach116134483ma_ch_
mache125925303ma_che
machos135217493ma_chos
machs125722563ma_chs
macro94718173ma_cro
manches143818623manches
manchet143317783manchet
mango85724323man_go
manihot121112053manihot
manito8518693manito
mano66536813man__o
march125622893march_
match125621103match_
mucho125013443_mucho
munch124917103munch_
nachos115014183na_chos
nance74721843nanc_e
nances83618643nances
nancy105214923nanc_y
narco76718243narc_o
natch105018223natch_
nuncio837973nuncio
orach105219233ora_ch_
orache114013593ora_che
pacha126518063pa_cha
painch133511323painch_
panache1458423panache
panchax2134983panchax
panino8315683panino
panocha1444983panocha
panoche1456383panoche
panto76129413pan_to
parch125123003parch_
patch125221223patch_
patchy16509573patchy
paunch13369853paunch_
paunchy17324443paunchy
pinch125619303pinch_
planch133711443planch_
planche14299753planche
ponchos143410703ponchos
prance104318573pranc_e
pranced123714043pranced
prancer113613383prancer
prances113618773prances
psycho1674533psycho
punch125118423punch_
punchy16398523punchy
rabato83413263rabato
raccoon1176163raccoon
race66746263ra_c_e
raced87635313ra_ced
racer75233023ra_cer
races74943243ra_ces
rachet115028973ra_chet
rachis114017653ra_chis
rack106234883ra_c_k
racks115028853ra_cks
racon75422143ra_con
racoon83814473ra_coon
racy95825683ra_c_y
radio64922493ra_dio
rah68052403ra__h_
rajah155711423rajah_
rajahs16497663rajahs
ralph1078743ralph_
ralphs1135373ralphs
ran38266623ran___
rancheros14255793rancheros
ranchers133311793ranchers
ranching141712043ranching
ranchman1546043ranchman
ranchmen1545833ranchmen
rancors9811373rancors
rancour987133rancour
rand55839573ran__d
randan7315253randan
random92513553random
rands65930453ran_ds
randy95022083ran_dy
ranee55438103ran_ee
ranees64623963ranees
rang56939163ran__g
range64728413ran_ge
ranged84824313ranged
ranger73925523ranger
ranges73826923ranges
rangy95320383ran_gy
rani46640113ran__i
ranid66429333ran_id
ranids75118703ranids
ranis55235833ran_is
rank85135533ran__k
ranked114620743ranked
ranker105021903ranker
rankle103414883rankle
rankly133910453rankly
ranks95225733ran_ks
ransom82410943ransom
rant45864683ran__t
ranted74324703ranted
ranter63826823ranter
rants55935343ran_ts
ranula6311813ranula
raphe104916423ra_phe
rascal8511123rascal
rash76039933ra_sh_
ratches123620463ratches
ratchet124218333ratchet
rath76037663ra_th_
rathe85821923ra_the
ratio55227583ra_tio
rato45436973ra__to
raunches1368053raunches
rayah116013503rayah_
rayahs12579193rayahs
reach105123883reach_
recto74520803r_ecto
reechy14367823reechy
retch104818303retch_
revanche1645003revanche
rho65924833r___ho
rhonchi1542493rhonchi
rich97025543r_ich_
roach105717003roach_
rondo65218373ron_do
rotch105815933rotch_
rotche114311983rotche
rouche114714313rouche
ruche104216763r_uche
salchow1544323salchow
sancta839833sancta
sandhi1038193sandhi
sandhog1275453sandhog
sangh95517453sangh_
sanghs105312063sanghs
santo56227283san_to
sauch104918773sauch_
sauchs115112233sauchs
stanch113812373stanch_
synch135011793synch_
synchro1544543synchro
synchs14408453synchs
tach96132753ta_ch_
tache106222373ta_che
tachs105820933ta_chs
taco67031353ta_c_o
tango66921173tan_go
tanto55724943tan_to
tench105620003tench_
trance84718763tranc_e
tranced104414173tranced
trances93919643trances
tranches132915513tranches
trench114211613trench_
unanchor1343093unanchor
unco66021403_unc_o
wacko145514383wa_cko
watch135617063watch_
waucht14399413waucht
wench136214783wench_
winch135016663winch_
wrench14439353wrench_
yacht13417393ya_cht

Search took 7 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 Filter1786911127160.376475242.0
2DLD Change Limit1127163005.65319939.1
3Display Results3003000.0963125.0
 (SQL Overall)1786913006.12529174.0
 
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.