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

191 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
gaucho125622(None) 
gauche1238551gauche
gauchos1345891gauchos
ancho104515292_ancho
gaucher1337232gaucher
guaco85012162guac_o
macho126120152ma_cho
mucho125013442_mucho
nacho105414372na_cho
rancho114310842rancho
sauch104918772sauch_
sauchs115112232sauchs
waucht14399412waucht
abmho1236793_abmho
ache96829823_a_che
achoo10315083_a_choo
achy126316093_a_chy
ahchoo1445713_ahchoo
altho86312603_altho
anchor113911973_anchor
anchos114214893_anchos
arch98628443_arch_
archon11311753_archon
arco68331543_arc_o
audio62917103_audio
aught95120703_aught
author939763_author
auto47432083_au_to
bach116131393ba_ch_
banco94019393banc_o
batch124620103batch_
bucko134614023_bucko
cacao95420003ca_cao
cache125122483ca_che
cachou13310613ca_chou
cancha134411613cancha
capuche1644433capuche
catch125120373catch_
catchy16559583catchy
caucus1039603caucus
caught124911683caught
claucht1445583claucht
concho134414253concho
couch125320113couch_
dacha114812573da_cha
datcha1266563datcha
douche124613223douche
duchy144310873_duchy
each95530583ea_ch_
echo96615953__echo
faucal11339963faucal
fauces114916153fauces
faucet115816553faucet
faugh125712963faugh_
gabbro11114953gabbro
gadjo1436913ga_djo
galago838903galago
galah95917623galah_
galahs105512673galahs
ganache1346203ganache
garcon92912483garcon
garth94720223garth_
garths104111503garths
gascon9339723gascon
gash86833023ga_sh_
gasohol1143533gasohol
gauchely1742743gauchely
gauchest1436293gauchest
gaud67025433gau__d
gauds75717723gau_ds
gaudy106611463gau_dy
gauge76117903gau_ge
gauged94713473gauged
gauger84714853gauger
gauges85915993gauges
gault65128473gau_lt
gaults74112773gaults
gaum75726423gau__m
gaumed104610323gaumed
gaums86217073gau_ms
gaun56427713gau__n
gaunt65430403gau_nt
gaur56723353gau__r
gaurs66317993gau_rs
gauss65613453gau_ss
gauze155712973gau_ze
gauzes164710633gauzes
gauzy18489213gau_zy
gazabo1834833gazabo
gazebo1833673gazebo
gazoo153112873ga_zoo
gazpacho2551263gazpacho
gecko124511113g_ecko
glucan936183glucan
glunch1255353glunch_
gotcha1234633gotcha
gouache1335033gouache
grouch12318473grouch_
grouchy16294243grouchy
grutch12285563grutch_
guacharo1442553guacharo
guacos94410313guacos
guano69213983g_uano
guck114922533g_uc_k
gucks123917303g_ucks
guiro63712093g_uiro
gulch113810603gulch_
gumbo104413583g_umbo
gush85424003g_ush_
gushy125213123g_ushy
gusto65414643g_usto
hatch135719593hatch_
haugh125114053haugh_
haughs13408563haughs
haunch14377343haunch_
heuch135312333heuch_
heuchs14447923heuchs
honcho14389373honcho
juco134716203_juc_o
laich105920713laich_
laichs115110893laichs
larch105919793larch_
latch104620463latch_
laugh94414373laugh_
laughs10489023laughs
launch11368063launch_
louche115212663louche
mach116134473ma_ch_
mache125925303ma_che
machos135217493ma_chos
machs125722563ma_chs
macro94718173ma_cro
manche133515103manche
march125622893march_
match125621103match_
mouch124715803mouch_
much115224033_much_
mucro94513723_mucro
nachos115014183na_chos
narco76718243narc_o
natch105018223natch_
naught104312493naught
nautch1144813nautch_
nucha10229793_nucha
ouch95724633_ouch_
pacha126518063pa_cha
parch125123003parch_
patch125221223patch_
patchy16509573patchy
paunch13369853paunch_
paunchy17324443paunchy
poncho133310113poncho
pouch124617083pouch_
pouchy16538663pouchy
psycho1674533psycho
ranch105019793ranch_
ranchos123911393ranchos
ratch104221363ratch_
raunch11358433raunch_
raunchy15284313raunchy
reecho11318653reecho
rouche114714313rouche
ruche104216763_ruche
salchow1544323salchow
sauce75121653sauc_e
sauced93913303sauced
saucer84314103saucer
sauces84919503sauces
saucy104615163sauc_y
saugh95318403saugh_
saughs104812053saughs
saughy13507463saughy
stucco1044253stucco
such96424813_such_
tach96132753ta_ch_
tache106222373ta_che
tachs105820933ta_chs
taco67031353ta_c_o
taught104312223taught
teuch105214853teuch_
touch106519393touch_
touche114916173touche
touchy145010503touchy
vouch134611903vouch_
wacko145514383wa_cko
watch135617063watch_
wauchts15285283wauchts
waugh125411683waugh_
waught133811043waught
yacht13417393ya_cht
yuch125818533_yuch_

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 Filter1786911127160.1561145455.1
2DLD Change Limit1127161917.40615219.6
3Display Results1911910.0633031.7
 (SQL Overall)1786911917.62523434.9
 
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.