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

269 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
filchers1628686(None) 
filcher15377791filcher_
filches153410721filche_s
belchers153510022belchers
ditchers143610362ditchers
fetchers16328862fetchers
fiches145219532fi_che_s
filched16307422filche_d
filers94623722fil__ers
fillers104320212fil_lers
filmers124211292fil_mers
filters103816552fil_ters
finches153914192finche_s
fishers134714722fi_shers
fitches153516192fitche_s
fitchets16307412fitchets
fitchews19274772fitchews
flichters1774172flichters
flickers17338882flickers
flinchers17295472flinchers
hitchers16379992hitchers
inchers123912522_inchers
pinchers153510612pinchers
pitchers153211482pitchers
welchers16338052welchers
winchers16319222winchers
zilches21326302zilche_s
aitches123014363aitche_s
archers124414573_archers
batchers153613273batchers
belcher143511493belcher_
belches143514343belche_s
benchers153611013benchers
bickers154316553bi_ckers
bilayers13296923bilayers
bilkers134711863bil_kers
billers94720833bil_lers
birches143412323birche_s
bitchery18236563bitchery
bitches144117063bitche_s
blithers134711233blithers
bluchers15359033bluchers
botchers153511543botchers
butchers153710183butchers
catchers153114063catchers
cinches144215773cinche_s
ciphers14379993ci_phers
circlers1235353circlers
cithers124315773ci_thers
cliches144213743cliche_s
clickers163910203clickers
clinchers16336263clinchers
coachers154312303coachers
couchers153513863couchers
culches143710743culche_s
dicers94720743di_c_ers
dickers144117663di_ckers
diethers1257453diethers
dilaters92513063dilaters
diluters9288113diluters
ditcher134012003ditcher_
ditches133215713ditche_s
dithers114016153di_thers
etchers123411293_etchers
facers115519443f_ac_ers
falces115216003falc_e_s
falconers1445323falconers
fallers103917993fal_lers
falters103916473fal_ters
fanciers13358083fanciers
farcers124713443farc_ers
fathers133916503f_athers
feathers143513243feathers
feldschers1941763feldschers
feldshers1643093feldshers
fellers104117543fel_lers
fencers123810623fenc_ers
fetcher153510393fetcher_
fetches153413893fetche_s
fiacres1237253fiacre_s
fibbers144510603fi_bbers
fibers114717523fi__bers
fibsters13126413fibsters
fices106031163fi_c_e_s
fiche134616743fi_che__
fichus14388113fi_ch_us
ficoes114613463fi_coe_s
fiddlers13328283fiddlers
fielders12156773fielders
fifers125414923fi__fers
fighters15269403fighters
figurers12254873figurers
filarees1187643filarees
filbert12411643fil_bert
filberts1334993fil_berts
filch134813323filch___
filching1736113filching
filer85433003fil__er_
files85441273fil__e_s
filets94718953fil__ets
filibegs1442223filibegs
filisters1237003filisters
filler94623623fil_ler_
filles94224523fil_le_s
fillets103414753fil_lets
fillies103420253fillie_s
filmer114112403fil_mer_
filmgoers1541983filmgoers
filmier1237503filmier_
filmless1344553filmless
filmsets1353413filmsets
filter94517633fil_ter_
filterers12206973filterers
filthier1434073filthier_
filths12389783filth__s
finders113717873fi_nders
fingers113418433fi_ngers
finishers1545353finishers
firers94922683fi__rers
firmers124711443fi_rmers
fisher124917143fi_sher_
fishery16397733fi_shery
fishes125221343fi_she_s
fitchee152710783fitche_e
fitchet153113563fitche_t
fitchew18276803fitche_w
fitters104517753fi_tters
fivers124420923fi__vers
fixers165112983fi__xers
fizzers18357003fi_zzers
flakers143613273f_lakers
flamers124616363f_lamers
flashers143912653flashers
flayers133912033f_layers
fleches153411443fleche_s
fleers96015793f_l_eers
fleshers14339443fleshers
fletchers17335533fletchers
flichter1664963flichter_
flicker163610623flicker_
flickery20365103flickery
fliers94417193f_l_iers
flincher16256583flincher_
flinches16358953flinche_s
flinders12439263flinders
flingers123410193flingers
flippers15338003flippers
flirters11337933flirters
flitches16388463flitche_s
flitters114312173flitters
flivvers1733113flivvers
flowers133413173f_lowers
flushers14279733flushers
fluters103713683f_luters
flyers125712803f_l_yers
folders113514393fol_ders
forcers124215713forc_ers
frillers11349873fril_lers
frothers14279813frothers
fuckers163611593f_uckers
fullers103817373ful_lers
furthers1436493furthers
gilders94212463gil_ders
gillers84216903gil_lers
gulches13398103gulche_s
hatchers163113173hatchers
hillers103718733hil_lers
hitcher153712003hitcher_
hitches153616273hitche_s
ichors11310423_i_chors
ickers123914183_i_ckers
incher114114033_incher_
inches114419673_inche_s
itches114916213_itche_s
jilters144211963jil_ters
kickers124013293ki_ckers
killers114215583kil_lers
kilters113813603kil_ters
kimchees1942943kimchees
kitchens17195783kitchens
leachers133712813leachers
lechers123313963_lechers
lichees123512783li_chees
lichens123510683li_chens
liches114724293li_che_s
lickers134118253li_ckers
lunchers13349563lunchers
lurchers13307153lurchers
lynchers16285453lynchers
marchers153710813marchers
matchers153012433matchers
miches134320733mi_che_s
milers84625163mil__ers
milkers134411613mil_kers
millers93621343mil_lers
milliers102611903milliers
milters93619093mil_ters
mincers113714853minc_ers
mithers123516733mi_thers
moochers15369123moochers
mulches143210673mulche_s
munchers15318773munchers
niches114419143ni_che_s
nickers134415093ni_ckers
notchers13279423notchers
ochers113915303__ochers
oilers64721193oil__ers
patchers153413303patchers
peachers153213843peachers
perchers153611523perchers
pickers153718093pi_ckers
piecers114112253piec_ers
pilchard1644553pilchard
pilchards1743923pilchards
pilfers1238963pil_fers
pilsners1035533pilsners
pincers113916503pinc_ers
pincher143812713pincher_
pinches144117933pinche_s
pinschers1644383pinschers
pishers123815753pi_shers
pitcher143813713pitcher_
pitches143617753pitche_s
poachers152910763poachers
punchers152610073punchers
ranchers133311793ranchers
reachers133515723reachers
ricers84120993ri_c_ers
richens12349733ri_chens
richer114015043ri_cher_
riches115022083ri_che_s
sighers113712183si_ghers
sillers73822103sil_lers
silvers104714043sil_vers
slicers94114923slic_ers
slickers143112553slickers
slithers114212953slithers
snitchers14166043snitchers
stitchers14147013stitchers
switchers17146633switchers
teachers133212393teachers
telphers1335473telphers
tickers133617723ti_ckers
tilers63523503til__ers
tillers73418743til_lers
tilters73315953til_ters
tithers104216733ti_thers
tochers123413093_tochers
touchers133611213touchers
twitchers17134533twitchers
ulcers839383_ulc_ers
vouchers16418623vouchers
watchers163511793watchers
welcher15319393welcher_
welches153710313welche_s
welshers14246813welshers
wenchers16319213wenchers
wiches144418753wi_che_s
wickers164114703wi_ckers
wilders113513503wil_ders
willers103517913wil_lers
wincers123415363winc_ers
wincher153410653wincher_
winches154714373winche_s
wishers133215213wi_shers
witchery19236093witchery
witches152715793witche_s
withers134417753wi_thers
zithers193911973zi_thers

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit1461622697.45619603.3
3Display Results2692690.1062537.7
 (SQL Overall)1786912697.98222386.7
 
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.