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

246 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
fleech1436734(None) 
fleece11369901fleece
fleecy14266481fleecy
flench144010811flench
fletch14388191fletch
leech104913211_leech
beech124315502_beech
bleach133611402bleach
blench133710452blench
breech13348262breech
clench133910052clench
fetch134913472f_etch
fleche14299302fl_eche
fleck148213592fl_eck
flee76238792flee__
fleeced13358152fleeced
fleecer12368032fleecer
fleeces12399642fleeces
fleeched17345822fleeched
fleeches16287082fleeches
fleer86020772flee_r
fleers96015792fleers
flees85828752flee_s
fleet85932332flee_t
fleets96915062fleets
flesh115013742fl_esh
flinch144010102flinch
flitch14928172flitch
flysch1732892flysch
french143511212french
leach105422522_leach
lech96825442_l_ech
letch105215802_letch
pleach134211242pleach
plench134010812plench
speech1347562speech
alec66430063al_ec_
alecs76620733al_ecs
alee46652323alee__
aleph10311393al_eph
almeh106214553alme_h
beach124623893_beach
beechy16397503_beechy
belch124415503_belch
bench125619503_bench
beseech1453873beseech
blanch133410853blanch
bleed85019803blee_d
bleeds95211593bleeds
bleep95013453blee_p
bleeps10499103bleeps
blotch13197143blotch
breach134213723breach
clach124617823cl_ach
cleek115514913clee_k
cleeks125010543cleeks
clinch133910353clinch
clutch13367753clutch
creesh11328333creesh
dreich12377723dreich
drench12369593drench
each95530583__each
elect74327033el_ect
elenchi1244723elenchi
etch95419143__etch
faeces114713123faeces
feces105625363f_eces
feck134923433f__eck
fee66862013f_ee__
feeb96924543f_ee_b
feebs106112683f_eebs
feed84538903f_ee_d
feeds94921143f_eeds
feel75233843f_ee_l
feels85223043f_eels
fees76450603f_ee_s
feet75352213f_ee_t
feeze174913823f_eeze
feh96136093f__e_h
fellah124910773fellah
fence105319913f_ence
fetich1479693fetich
fierce11348913fierce
filch134813323f_ilch
finch135416973f_inch
fitch134816873f_itch
flack144519413fl_ack
flash115716213fl_ash
flea75628493fl_e_a
fleam106017283fl_eam
fleams115011943fleams
fleas86423663fl_eas
fleches153411443fl_eches
flecks154310803flecks
flecky18387653flecky
fled85429773fl_e_d
fledge11439313fledge
fledgy14414913fledgy
fleecers13325933fleecers
fleeching18305013fleeching
fleecier1334763fleecier
fleecily1644013fleecily
fleecing14347573fleecing
fleeing113511293fleeing
fleered11309503fleered
fleeted113310233fleeted
fleeter103210363fleeter
fleetly1336323fleetly
flemish1536373flemish
flenched17267963flenched
flenches163410533flenches
flense938903flense
fleshy15406283fleshy
fletched17306693fletched
fletcher16306663fletcher
fletches16308853fletches
fleury12417353fleury
flew105824253fl_e_w
flews115316443fl_ews
flex146123473fl_e_x
flexed17419093flexed
flexes164512953flexes
flexor1634503flexor
fley106626853fl_e_y
fleyed13408813fleyed
fleys117015603fl_eys
flic96223733fl_ic_
flick145017213fl_ick
flics105418363fl_ics
flied96519433flie_d
flier86023403flie_r
fliers94417193fliers
flies85630713flie_s
fliest94718433fliest
floc95922123fl_oc_
flocci1335023flocci
flock144717423fl_ock
flocs105519233fl_ocs
floe76129773floe__
floes85528143floe_s
flue75329853flue__
flued95021253flue_d
fluency1545353fluency
fluent9313933fluent
flues84626923flue_s
fluish1239333fluish
flush115116073fl_ush
flyer114916253flye_r
flyers125712803flyers
free75940183free__
freed95223543free_d
freely12310963freely
freer86021243free_r
freers94717303freers
frees86131393free_s
freest95318283freest
freeze18349513freeze
fresco1136473fresco
fresh115012203f_resh
glee55239063glee__
gleed75320573glee_d
gleeds84711623gleeds
gleek105315103glee_k
gleeks11489673gleeks
glees65027593glee_s
gleet65532343glee_t
gleets75315053gleets
gleety10479193gleety
glitch12286353glitch
glunch1255353glunch
heuch135312333_heuch
ileac75814173ileac_
kench145513923_kench
ketch144912023_ketch
klatch15445933klatch
kvetch1832993kvetch
laich105920713_laich
larch105919793_larch
latch104620463_latch
leachy14419733_leachy
leash85519213_leash
lee36068143_lee__
leeched13369503_leeched
leeches123911933_leeches
leek85331733_lee_k
leeks95318893_leeks
leer46239353_lee_r
leers54828983_leers
leery85919133_leery
lees45455883_lee_s
leet45957903_lee_t
leets54927123_leets
lich96230843_l_ich
loach105116363_loach
loch95527133_l_och
lunch104917243_lunch
lurch104814633_lurch
lych126015763_l_ych
lynch13468983_lynch
merch125417963_merch
oleic7313333oleic_
peach125422493_peach
pech116125453__pech
perch124518833_perch
planch133711443planch
preach133613923preach
quench2036633quench
reach105123883_reach
reecho11318653_reecho
reechy14367823_reechy
retch104818303_retch
samech13277033samech
screech1435223screech
select82621173select
sheesh1237813sheesh
sheuch14267043sheuch
sketch1535363sketch
slatch114510533slatch
sleek94619043slee_k
sleeks104512463sleeks
sleeky13398963sleeky
sleep74920183slee_p
sleeps83913323sleeps
sleepy11479413sleepy
sleet55639133slee_t
sleets64318873sleets
sleety94112653sleety
sleeve93411593sleeve
sleigh10258203sleigh
sleuth937233sleuth
slouch11438523slouch
sneesh945893sneesh
stench114111163stench
teach105221123_teach
tech95925443__tech
teeth87315853_teeth
tench105620003_tench
teuch105214853_teuch
trench114211613trench
vetch134411843_vetch
welch134411493_welch
wench136214783_wench
wrench14439353wrench
wretch14326533wretch
yecch15558093_yecch
yech127220533__yech

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 Limit1127162465.61020092.0
3Display Results2462460.0763236.8
 (SQL Overall)1786912466.06229477.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.