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

281 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
flench14401081(None) 
blench133710451blench
clench133910051clench
fleech14367341fleech
fletch14388191fletch
flinch144010101flinch
french143511211french
plench134010811plench
bench125619502_bench
blanch133410852blanch
bleach133611402bleach
clinch133910352clinch
drench12369592drench
elenchi1244712elenchi
fence105319912f_ence
fetch134913472f_etch
finch135416972f_inch
fleche14299302fle_che
fleck148213592fle_ck
fleece11369902fleece
fleecy14266482fleecy
flenched17267962flenched
flenches163410532flenches
flense938902flense
flesh115013742fle_sh
flitch14928172flitch
fluency1545352fluency
flysch1732892flysch
glunch1255352glunch
kench145513922_kench
leach105422522_leach
lech96825442_le_ch
leech104913212_leech
letch105215802_letch
lunch104917242_lunch
lynch13468982_lynch
planch133711442planch
pleach134211242pleach
quench2036632quench
stench114111162stench
tench105620002_tench
trench114211612trench
wench136214782_wench
wrench14439352wrench
agency1237033agency
alec66430063ale_c_
alecs76620733ale_cs
alencon945733alencon
aleph10311393ale_ph
beach124623893_beach
beech124315503_beech
belch124415503_belch
blenched16358053blenched
blencher15308393blencher
blenches153310763blenches
blend85317453blen_d
blende95413443blende
blends96012883blends
blenny1156203blenny
blent76230953blen_t
blotch13197143blotch
branch134014773branch
breach134213723breach
breech13348263breech
brunch13329353brunch
bunch125118603_bunch
chinch163911233chinch
cinch124516243_cinch
clach124617823cl_ach
clenched16257763clenched
clencher15277973clencher
clenches152910953clenches
clutch13367753clutch
conch124620073_conch
cranch133613533cranch
crunch13349503crunch
dreich12377723dreich
dunch115316263_dunch
each95530583__each
elect74327033ele_ct
elenchic1544223elenchic
elenchus1343633elenchus
etch95419143__etch
faena85014203faen_a
faenas94412763faenas
faience1237513faience
fancy134615483f_ancy
feck134923433f_e_ck
feh96136093f_e__h
fellah124910773fellah
fen66851353f_en__
fenced124412713f_enced
fencer114613533f_encer
fences114617113f_ences
fend84832973f_en_d
fends96324973f_ends
fenny115115133f_enny
fens76139763f_en_s
fetich1479693fetich
fiance11310743fiance
fiend95312983fien_d
fiends104110293fiends
fierce11348913fierce
filch134813323f_ilch
finca104714503f_inca
fitch134816873f_itch
flack144519413fl_ack
flamenco1543193flamenco
flan76134183flan__
flanes94522423flanes
flange103411973flange
flank124618093flan_k
flanks133913403flanks
flans85327973flan_s
flash115716213fl_ash
flea75628493fle__a
fleam106017283fle_am
fleams115011943fleams
fleas86423663fle_as
fleches153411443fle_ches
flecks154310803flecks
flecky18387653flecky
fled85429773fle__d
fledge11439293fledge
fledgy14414913fledgy
flee76238793fle__e
fleeced13358153fleeced
fleecer12368033fleecer
fleeces12399643fleeces
fleeched17345823fleeched
fleeches16287083fleeches
fleer86020773fle_er
fleers96015793fleers
flees85828753fle_es
fleet85932333fle_et
fleets96915063fleets
flemish1536373flemish
flenching18296703flenching
flensed1136613flensed
flenser1036783flenser
flenses1039473flenses
fleshy15406283fleshy
fletched17306693fletched
fletcher16306663fletcher
fletches16308853fletches
fleury12417353fleury
flew105824253fle__w
flews115316443fle_ws
flex146123473fle__x
flexed17419083flexed
flexes164512953flexes
flexor1634503flexor
fley106626853fle__y
fleyed13408813fleyed
fleys117015603fle_ys
flic96223733fl_ic_
flick145017213fl_ick
flics105418363fl_ics
flinched17316703flinched
flincher16256583flincher
flinches16358953flinches
fling97023513flin_g
flings106715283flings
flint87333503flin_t
flints95617453flints
flinty126112493flinty
floc95922123fl_oc_
flocci1335023flocci
flock144717423fl_ock
flocs105519233fl_ocs
flong95815683flon_g
flongs105010493flongs
florence1347063florence
flounce1235413flounce
flouncy1543673flouncy
fluent9313933fluen_t
fluish1239333fluish
flung95114583flun_g
flunk125014383flun_k
flunks13469863flunks
flunky16408093flunky
flush115116073fl_ush
franc104615413franc_
francs114112193francs
frena85915273fren_a
frenched17299433frenched
frenches163311633frenches
frenum1188803frenum
frenzy2135883frenzy
fresco1136473fresco
fresh115012203fre_sh
glance94312313glance
glen56027203glen__
glens66519853glen_s
glitch12286353glitch
grinch1238473grinch
haunch14377343haunch
hence104920043_hence
heuch135312333_heuch
hunch136416213_hunch
ileac75814173ileac_
inch95420823__inch
ketch144912023_ketch
klatch15445933klatch
kvetch1832993kvetch
laich105920713_laich
lance75126723_lance
larch105919793_larch
latch104620463_latch
launch11368063launch
leachy14419733_leachy
leash85519213_leash
lend56233673_len_d
lends65326253_lends
lenes54738523_lenes
length1046103_length
lenis56326863_lenis
leno47331393_len_o
lenos56024863_lenos
lens46146493_len_s
lense54523433_lense
lent46360533_len_t
lento57223393_lento
lich96230843_l_ich
loach105116363_loach
loch95527133_l_och
lurch104814633_lurch
lych126015763_l_ych
mensch13387093_mensch
mensh105413553_mensh
merch125417963_merch
munch124917103_munch
offence1545353offence
oleic7313333oleic_
painch133511323painch
paunch13369853paunch
peach125422493_peach
pech116125453_pe_ch
pence94924453_pence
perch124518833_perch
pinch125619303_pinch
planche14299753planche
plena75816393plen_a
plenches153110623plenches
plenish1239943plenish
plenty11311413plenty
plenum1039503plenum
plinth11310453plinth
preach133613923preach
punch125118423_punch
ranch105019793_ranch
raunch11358433raunch
reach105123883_reach
retch104818303_retch
sheuch14267043sheuch
silence9310213silence
sketch1535363sketch
slatch114510533slatch
sleigh10258203sleigh
sleuth937233sleuth
slouch11438523slouch
speech1347563speech
spence103813793spence
stanch113812373stanch
stenchy15256213stenchy
synch135011793_synch
teach105221123_teach
tech95925443_te_ch
tenth85421833_tenth
teuch105214853_teuch
thence112010843thence
unclench1544143unclench
valence1268773valence
valency1565463valency
vetch134411843_vetch
welch134411493_welch
whence14187923whence
winch135016663_winch
wretch14326533wretch
yecch15558093_yecch
yech127220533_ye_ch

Search took 6 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.1401276364.3
2DLD Change Limit1127162815.42320784.8
3Display Results2812810.0933021.5
 (SQL Overall)1786912815.65631593.2
 
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.