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

252 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
lurchers1330715(None) 
lunchers13349561lunchers
lurcher12338131lurcher_
lurches123311661lurche_s
archers124414572_archers
bluchers15359032blu_chers
burghers1435632burghers
butchers153710182butchers
curches143512742curche_s
furthers1436492furthers
larches124416452larche_s
launchers1454332launchers
leachers133712812leachers
lechers123313962l_echers
luncher123111412luncher_
lunches124115442lunche_s
lurched13358032lurche_d
lurers64217492lur__ers
lurkers113910082lur_kers
lynchers16285452lynchers
marchers153710812marchers
munchers15318772munchers
murthers1336542murthers
perchers153611522perchers
punchers152610072punchers
archer115016243_archer_
archery15478063_archery
arches114822043_arche_s
batchers153613273batchers
belchers153510023belchers
benchers153611013benchers
birches143412323birche_s
blanchers16307433blanchers
bleachers16297923bleachers
blenchers16356723blenchers
blucher143310223blu_cher_
blurters10348373blur_ters
blushers133911293blu_shers
botchers153511543botchers
brunchers16296253brunchers
brushers134210573brushers
buckers153517453bu_ckers
bunches144116033bunche_s
burblers12399263burblers
burgers103918573bur_gers
burgher1337003burgher_
buriers94017193bur_iers
burkers133716623bur_kers
burlers94120273bur_lers
burners94115673bur_ners
burrers93814493bur_rers
bursters1038983bursters
burthens1335383burthens
bushers124018803bu_shers
butcher143411163butcher_
butchery18326253butchery
butches144315363butche_s
catchers153114063catchers
churches1846433churche_s
circlers1235353circlers
clenchers16276553clenchers
clinchers16336263clinchers
clutches15307923clutche_s
coachers154312303coachers
couchers153513863couchers
crunchers16316243crunchers
crushers134010093crushers
culches143710743culche_s
curbers115514383cur_bers
curdlers11368493curdlers
curers84923193cur__ers
curlers94218073cur_lers
curriers103410753curriers
cursers94317163cur_sers
cutchery18265173cutchery
cutches143216463cutche_s
ditchers143610363ditchers
druthers1275793druthers
duchess1335553du_chess
duckers143214713du_ckers
dunches133312583dunche_s
enrichers1444133enrichers
etchers123411293_etchers
euchres1288663eu_chres
farcers124713443farc_ers
fetchers16328863fetchers
filchers16286863filchers
fletchers17335533fletchers
flinchers17295473flinchers
flushers14279733flu_shers
forcers124215713forc_ers
fuckers163611593fu_ckers
furlers104214223fur_lers
furriers11369493furriers
further1337003further_
glunches1436263glunche_s
gulches13398113gulche_s
gurshes112210033gurshe_s
gushers113512513gu_shers
hatchers163113173hatchers
hitchers16379993hitchers
hunches153913463hunche_s
hurdlers12337493hurdlers
hurlers103714323hur_lers
hurriers11358893hurriers
hurters103413643hur_ters
hutches153613523hutche_s
inchers123912523_inchers
juicers1636153juic_ers
kuchens1634713ku_chens
lacers85225253l_ac_ers
laches116528353l_ache_s
lackers134120543l_ackers
lancers93616643lanc_ers
lanciers10308543lanciers
larceners1135993larceners
larchen12479633larche_n
larders83516943lar_ders
larkers113014513lar_kers
lashers104121833l_ashers
latches123320133latche_s
latchets133410013latchets
lathers104321883l_athers
laughers1235923laughers
launcher1365563launcher_
launches1387903launche_s
leacher124014843leacher_
leaches123319343leache_s
leathers114215083leathers
lecher113415853l_echer_
lechery15257643l_echery
leches115421313l_eche_s
leeches123911933leeche_s
letches124015483letche_s
lichees123512783l_ichees
lichens123510683l_ichens
liches114724293l_iche_s
lickers134118253l_ickers
loaches123613983loache_s
loathers113310443loathers
lockers133516923l_ockers
lorimers1036613lorimers
loriners839963loriners
lubbers113913723lu_bbers
lucern846103lu_c_ern
lucerns935753lu_c_erns
luces75528433lu_c_e_s
lucifers1334163lucifers
lucres84513303lu_cre_s
lugers74617023lu__gers
luggers93713483lu_ggers
lullers73213353lu_llers
lumbers113815913lu_mbers
lumpers113514483lu_mpers
lunched133911823lunche_d
luncheon1344013luncheon
luncheons1443603luncheons
lungers83817093lu_ngers
lunkers113414603lu_nkers
lurch104814633lurch___
lurching14277333lurching
lurer54625313lur__er_
lures56138533lur__e_s
lurexes1436073lurexe_s
lurker103613293lur_ker_
lusher93818763lu_sher_
lushes94022743lu_she_s
lusters73921443lu_sters
luthern1037653lu_thern
lutherns1136293lu_therns
luthiers1135163luthiers
lychees15516783l_ychees
lyches144213613l_yche_s
lyncher15366553lyncher_
lynches15378873lynche_s
marcher143912973marcher_
marches143921173marche_s
matchers153012433matchers
mercers114412773merc_ers
merches144013763merche_s
moochers15369123moochers
muches134718993mu_che_s
muckers153612803mu_ckers
mulches143210673mulche_s
muncher143610373muncher_
munches144215793munche_s
murders103311363mur_ders
murther1237953murther_
mushers124016443mu_shers
mutches143314283mutche_s
northers1139333northers
notchers13279423notchers
nursers74311833nur_sers
ochers113915303__ochers
ouches114322183ou_che_s
parches143720003parche_s
patchers153413303patchers
peachers153213843peachers
percher143313423percher_
perches143717953perche_s
pinchers153510613pinchers
pitchers153211483pitchers
pluckers16316553plu_ckers
poachers152910763poachers
porches143815673porche_s
puckers153514673pu_ckers
puncher143311673puncher_
punches144816133punche_s
purchasers1742553purchasers
purflers13216963purflers
purgers104714003pur_gers
pursers93916093pur_sers
pursuers10376523pursuers
pushers123814503pu_shers
quashers20186803quashers
quenchers2343173quenchers
quiches2139333quiche_s
qurshes19228573qurshe_s
ranchers133311793ranchers
reachers133515723reachers
ruches114819583ru_che_s
rushers103816103ru_shers
scorchers16145513scorchers
scutchers16175643scutchers
searchers14197353searchers
slouchers14185623slouchers
suckers133717623su_ckers
surfers103614133sur_fers
surgers83517483sur_gers
teachers133212393teachers
tochers123413093_tochers
torchere1347683torchere
torcheres1446863torcheres
torches123715443torche_s
torchiers1445073torchiers
touchers133611213touchers
truckers14279013truckers
tuckers134014353tu_ckers
turners73912893tur_ners
turtlers8258203turtlers
tusches1237903tusche_s
ulcers839383_ulc_ers
urchins1238863_urchins
ureters7311823_ureters
urgers73313623_ur_gers
ushers94415533_u_shers
vouchers16418623vouchers
watchers163511793watchers
welchers16338053welchers
wenchers16319213wenchers
winchers16319223winchers
wuthers133711523wu_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.436409841.7
2DLD Change Limit1461622528.23617746.7
3Display Results2522520.2031241.4
 (SQL Overall)1786912528.87520134.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.