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

282 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
kruller114515(None) 
cruller968751cruller
krullers1234131krullers
crueler939022crueler
crueller1056452crueller
crullers1047302crullers
culler84322252_culler
driller84311882driller
droller84110282droller
duller74017702_duller
friller104111742friller
fuller94220382_fuller
griller84513352griller
grueler837022grueler
grueller935332grueller
huller93919102_huller
killer104917952k_iller
knoller11285912knoller
luller63415482_luller
muller83820352_muller
puller83820812_puller
roller63919792_roller
ruler54923342_ru_ler
rulier65016352_rulier
sculler99812152sculler
triller74215892triller
troller73913172troller
aulder7511453_aulder
awfuller1442423awfuller
baller83825203_baller
biller84923483_biller
boulder103411343boulder
boulle84614613boulle_
boulles93114123boulles
brailler1036883brailler
brawler124310233brawler
bridler103811073bridler
broiler92911753broiler
bruiser9349573bruiser
bruiter93710633bruiter
brusher123813003brusher
brusker13437853brusker
bugler94717723_bugler
bulger94917353_bulger
bulled94626493_bulled
bullet84528613_bullet
bullier94116433_bullier
burbler114412423burbler
burler84723833_burler
burlier93514413burlier
butler84220033_butler
caller85125483_caller
caroller1039203caroller
caulker13456893caulker
chiller124112183chiller
coruler9311713coru_ler
coulter94115603coulter
coupler114713013coupler
cradler102910513cradler
crawler123510463crawler
cruder95612383cru_der
cruiser93410433cruiser
crumber13339643crumber
crupper13338563crupper
crusher124412323crusher
culled94022473_culled
cullers93418853_cullers
cullet84727313_cullet
culver113010633_culver
curdler103511563curdler
curler85221323_curler
curlier93314183curlier
cutler84718033_cutler
dialler848813dialler
doubler103110083doubler
drawler11338593drawler
drilled94711673drilled
drillers9429723drillers
drolled93810223drolled
drollery12314793drollery
drubber12357863drubber
drudger10328323drudger
drumlier1134523drumlier
drummer12407503drummer
drunker12326633drunker
dueler74213683_dueler
dueller8329833dueller
dulled84719423_dulled
dweller11297273dweller
enroller867183enroller
eviller1056673eviller
faller94621233_faller
feller94419553_feller
filler94623623_filler
fouler93614903fou_ler
frailer10319943frailer
frilled113911603frilled
frillers11349873frillers
frillier1136513frillier
fruiter10309683fruiter
fueler94313933_fueler
fueller10279963fueller
fulled103820653_fulled
fullers103817373_fullers
fullery13337973_fullery
furler93616403_furler
giller74519733_giller
grille74315743grille_
grilled94012833grilled
grillers93810813grillers
grillery12355503grillery
grilles83715023grilles
growler11318973growler
grubber12417913grubber
grudger10368313grudger
grueled937133grueled
gruelers936173gruelers
gruelled1034893gruelled
gruellers1034183gruellers
gruffer1475793gruffer
grumbler13866683grumbler
grummer12338783grummer
grunger9389783grunger
grunter83110783grunter
gulled84521373_gulled
gullet74924833_gullet
gulley104213163_gulley
gulper93410213_gulper
hauler95015123hau_ler
haulier1059943haulier
heller93322513_heller
hiller94421633_hiller
holler93520613_holler
hulled103920013_hulled
hullers103616263_hullers
hurdler113610003hurdler
hurler94717223_hurler
iller54821293__iller
kegeler1245493kegeler
kegler11398243k_egler
kelter103214383k_elter
killed113918773k_illed
killers114215583k_illers
kilter103714343k_ilter
kindler12309983kindler
kittler11338163kittler
kneeler11277573kneeler
knelled12338993knelled
knolled12296573knolled
knollers12255143knollers
knuckler1383623knuckler
knurled1244653knurled
knurlier1242883knurlier
kraaled12254983kraaled
krater104014313kr_ater
kreutzer2141273kreutzer
kreuzer2032353kreuzer
krill94213643krill__
krills104211283krill_s
krimmer15376873krimmer
kroner104612573kr_oner
kultur1034433k_ultur
kvelled15276063kvelled
loller63315283_loller
lulled74516443_lulled
lullers73213353_lullers
mauler84416713mau_ler
miller84625413_miller
moulder10389803moulder
moulter93812423moulter
mulled94721553_mulled
mullen83714763_mullen
mullers93217303_mullers
mullet84126823_mullet
mulley114013453_mulley
nulled74318273_nulled
poller83921853_poller
poulter93712013poulter
prilled104713003prilled
prowler123310013prowler
pruner83413453pru_ner
puler74826623_pu_ler
pulled94322193_pulled
pullers93618483_pullers
pullet84026333_pullet
pulley113713403_pulley
pulper103513273_pulper
pulser84215193_pulser
purfler12248733purfler
purpler11289273purpler
queller16289293queller
railer64524933_railer
rallier73816273_rallier
realer63528593_realer
reeler63822573_reeler
relier65826183_relier
reroller8258753reroller
rifler94014263_rifler
rille55728733_rille_
rilled74525653_rilled
rilles64725503_rilles
rillet64828853_rillet
rolfer94412273_rolfer
rolled74220243_rolled
rollers73117473_rollers
rubber104715793_rubber
rubier84814743_rubier
ruble74521253_ruble_
rubles83921703_rubles
rudder83812803_rudder
ruder65320543_ru_der
ruer46127563_ru__er
ruffler13369723_ruffler
rugger84414513_rugger
ruiner64013643_ruiner
rule49938423_ru_le_
ruled65822523_ru_led
rulers64317093_ru_lers
rules55234253_ru_les
rumbler113514113_rumbler
rummer104715483_rummer
runlet63821413_runlet
runner63814463_runner
rusher94019653_rusher
rustler73512343_rustler
sculker13318323sculker
sculled102911693sculled
scullers103510483scullers
scullery13296333scullery
seller63824603_seller
sheller103515893sheller
shriller1136823shriller
siller64026063_siller
skulker10325683skulker
skulled12317403skulled
smaller93410333smaller
smeller94212793smeller
sneller73512853sneller
spaller92713473spaller
speller95415153speller
spiller92914333spiller
squaller1736083squaller
stiller73414303stiller
stroller848183stroller
sulker104015923_sulker
sullen62914293_sullen
surlier72915443surlier
sutler63718393_sutler
sweller103012473sweller
swiller103211663swiller
taller63721963_taller
teller63519823_teller
thriller1165553thriller
tiller64222543_tiller
toller63819443_toller
trailer73015393trailer
trawler104011903trawler
trifler103912153trifler
trilled84116313trilled
trillers83613493trillers
trolled84312263trolled
trollers83211213trollers
trolley10328753trolley
troubler1035293troubler
trucker134010733trucker
truckler14297453truckler
trudger9338733trudger
truer54916643tru__er
trull54012673trull__
trulls64110283trull_s
trundler9256153trundler
trusser74010263trusser
truster73114313truster
tulle54019933_tulle_
tulles63218893_tulles
turtler72610323turtler
ulcer7310753__ulcer
unrulier845333unrulier
vaulter10257713vaulter
willer94021063_willer
wofuller1442403wofuller
yeller94214513_yeller

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 Filter1786911340270.393454684.5
2DLD Change Limit1340272826.36021073.4
3Display Results2822820.0933032.3
 (SQL Overall)1786912826.84626101.5
 
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.