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

286 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
french14351121(None) 
drench12369591drench
flench144010811flench
trench114211611trench
wrench14439351wrench
bench125619502_bench
blench133710452blench
branch134014772branch
breach134213722breach
breech13348262breech
brunch13329352brunch
clench133910052clench
cranch133613532cranch
crunch13349502crunch
dreich12377722dreich
fence105319912f_ence
fetch134913472f_etch
finch135416972f_inch
fleech14367342fleech
fletch14388192fletch
flinch144010102flinch
franc104615412franc_
francs114112192francs
frena85915272fren_a
frenched17299432frenched
frenches163311632frenches
frenum1188802frenum
frenzy2135882frenzy
fresco1136472fresco
fresh115012202fre_sh
grinch1238472grinch
kench145513922_kench
plench134010812plench
preach133613922preach
quench2036632quench
ranch105019792_ranch
reach105123882_reach
retch104818302_retch
stench114111162stench
tench105620002_tench
wench136214782_wench
wretch14326532wretch
afresh1255503afre_sh
agency1237033agency
arch98628443ar__ch
ardency1346483ardency
areca75618633are_ca
areic73219393areic_
arena55323813aren_a
arenas65021993arenas
arene55329413aren_e
arenes64928393arenes
beach124623893_beach
bedrench1644153bedrench
beech124315503_beech
belch124415503_belch
blanch133410853blanch
bleach133611403bleach
brach126123303br_ach
branchy17357913branchy
breath113916263breath
bren65629563bren__
brens75823363bren_s
brent75734133bren_t
brents84717273brents
broach133611113broach
bronc91714343bronc_
bronchi14176313bronchi
broncho14206463broncho
bronco10179493bronco
broncs101611153broncs
brooch13368443brooch
bunch125118603_bunch
chinch163911223chinch
cinch124516243_cinch
clinch133910353clinch
conch124620073_conch
cratch134110793cratch
craunch1464443craunch
creche13310763cre_che
creesh11328333creesh
crenel84213063crenel
crotch133410083crotch
crouch133910203crouch
crunchy17324763crunchy
crutch13408243crutch
dreck124812803dre_ck
dreigh11246443dreigh
drenched15247913drenched
drencher14257213drencher
drenches14309803drenches
dunch115316263_dunch
each95530583__each
elenchi1244713elenchi
entrench13115723entrench
erect74129333ere_ct
erenow937373erenow
etch95419143__etch
faena85014203faen_a
faenas94412763faenas
faience1237513faience
fancy134615483f_ancy
feck134923433f_e_ck
feh96136093f_e__h
fen66851353f_en__
fenced124412713f_enced
fencer114613533f_encer
fences114617113f_ences
fend84832973f_en_d
fends96324973f_ends
fenny115115133f_enny
fens76139763f_en_s
fern76129323fern__
ferns85220083fern_s
ferny115816183fern_y
fervency1944383fervency
fetich1479693fetich
fiance11310743fiance
fiend95312983fien_d
fiends104110293fiends
fierce11348913fierce
filch134813323f_ilch
finca104714503f_inca
fitch134816873f_itch
fleche14299303fle_che
fleck148213593fle_ck
fleece11369903fleece
fleecy14266483fleecy
flenched17267963flenched
flenches163410533flenches
flense938903flense
flesh115013743fle_sh
flitch14928173flitch
florence1347063florence
fluency1545353fluency
flysch1732893flysch
fraena938063fraen_a
fraenum1255703fraenum
frank124417513fran_k
franks134912733franks
freak125115243fre_ak
freaks134713063freaks
freaky16439233freaky
free75940183fre__e
freed95223543fre_ed
freely12310953freely
freer86021243fre_er
freers94717303freers
frees86131393fre_es
freest95318283freest
freeze18349513freeze
freight1447603freight
fremd115010323fre_md
frenchify2342573frenchify
frenching18267753frenching
frenula1045623frenula
frenums1236203frenums
frere85617723fre_re
freres94716173freres
frescos1236813frescos
fresnel1035893fresnel
fret75845043fre__t
frets85523403fre_ts
fretty1249223fretty
friend10388933frien_d
friends11396743friends
fringe104013953fringe
fringy13309263fringy
frith115922033fr_ith
frock145314653fr_ock
frond95316343fron_d
fronds106412343fronds
frons86124043fron_s
front85029223fron_t
fronts94415793fronts
frosh115713403fr_osh
froth115919283fr_oth
frounce1236153frounce
glunch1255353glunch
greenth11116723greenth
grouch12318473grouch
grutch12285563grutch
haunch14377343haunch
hence104920043_hence
heuch135312333_heuch
hunch136416213_hunch
inch95420823__inch
intrench1396593intrench
irenic8311103irenic
irenics937833irenics
ketch144912023_ketch
kvetch1832993kvetch
launch11368063launch
leach105422523_leach
lech96825443_le_ch
leech104913213_leech
letch105215803_letch
lunch104917243_lunch
lynch13468983_lynch
mensch13387083_mensch
mensh105413553_mensh
merch125417963_merch
munch124917103_munch
offence1545353offence
orach105219233or_ach
painch133511323painch
paunch13369853paunch
peach125422493_peach
pech116125453_pe_ch
pence94924453_pence
perch124518833_perch
pinch125619303_pinch
planch133711443planch
pleach134211243pleach
prance104318573prance
preachy17307313preachy
preact103220393preact
prelunch1543433prelunch
prepunch1743643prepunch
prince104114763prince
punch125118423_punch
rance75028513_rance
rancho114310853_rancho
ratch104221363_ratch
raunch11358433raunch
react74634333_react
rec55645463_re_c_
recce9514563_recce
reck106130563_re_ck
recs65734183_re_cs
reecho11318653_reecho
reechy14367823_reechy
renal55929503_renal
rend56136573_ren_d
rends65129953_rends
renew83917513_renew
renig64518913_renig
renin54830033_renin
rent46661243_ren_t
rente54733783_rente
rents55935183_rents
resh76523453_re_sh
retrench1346283retrench
rich97025543_r_ich
roach105717003_roach
rotch105815933_rotch
screech1435213screech
scrunch1444033scrunch
sheuch14267043sheuch
sketch1535353sketch
speech1347563speech
spence103813793spence
stanch113812373stanch
stenchy15256213stenchy
stretch1236413stretch
synch135011793_synch
teach105221123_teach
tech95925443_te_ch
tenth85421833_tenth
teuch105214853_teuch
thence112010843thence
trance84718763trance
tranche123312223tranche
trefah1235093trefah
trenched14289853trenched
trencher13279313trencher
trenches133512603trenches
trend64817453tren_d
trends75513543trends
trendy10469603trendy
upreach1444693upreach
ureic74514463ureic_
urgency1345663urgency
vetch134411843_vetch
welch134411493_welch
whence14187923whence
winch135016663_winch
wreath124111193wreath
wreck144611043wre_ck
wren78221683wren__
wrenched17748133wrenched
wrencher16287783wrencher
wrenches163210233wrenches
wrens85016243wren_s
yecch15558093_yecch
yech127220533_ye_ch

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.1431249587.4
2DLD Change Limit1127162866.00018786.0
3Display Results2862860.1102600.0
 (SQL Overall)1786912866.25328576.8
 
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.