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

423 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
kittler1133816(None) 
kittle104012171kittle_
kittled12388191kittled
kittles113012491kittles
littler7348551littler
battler94113382battler
bitter84622672bitt_er
bittier94211662bittier
bottler94211882bottler
brittler10165982brittler
fitter94120032fitt_er
guttler8369162guttler
hitter94419862hitt_er
jitter133314992jitt_er
kettle104311612kettle_
kettles113411612kettles
killer104917952ki_ller
kilter103714342kilt_er
kindler12309982kindler
kirtle10309472kirtle_
kirtled12287032kirtled
kirtles11309662kirtles
kiter95523212ki_t_er
kitted115114832kitt_ed
kittel10368872kitt_el
kitten104611482kitt_en
kitties113213622kitties
kittlest12297572kittlest
knitter11348132knitt_er
litter64324852litt_er
little63312162little_
littles73212782littles
mottler94410342mottler
nettler7349502nettler
nittier73512242nittier
rattler74012742rattler
ritter63822422ritt_er
settler73410652settler
sitter63323382sitt_er
skitter113810402skitt_er
skittle1135532skittle_
skittles1245762skittles
tattler73112212tattler
titter63421162titt_er
tittle63613322tittle_
tittles73413252tittles
vittle94711752vittle_
vittled11347342vittled
vittles103211112vittles
whittler1495192whittler
wittier103910822wittier
antler64615553_antler
batter84928873batt_er
battier93515713battier
battle85217863battle_
battled104213123battled
battlers104110973battlers
battles94517683battles
beetler938043beetler
belittler1142493belittler
better84723703bett_er
biller84923483bi_ller
birler85715083bi_rler
bister84922763bist_er
biter75030033bi_t_er
bitsier9379073bitsier
bitted94418483bitt_ed
bitten84715123bitt_en
bitterer10309773bitterer
bittern94810683bitt_ern
bitters94920363bitt_ers
bottle84916073bottle_
bottled104611233bottled
bottlers103810013bottlers
bottles94216273bottles
brittle9168603brittle_
brittled11186093brittled
brittles10178653brittles
bustler94012573bustler
butler84220033_butler
butter84724233butt_er
cattier93317073cattier
cattle85118903cattle_
chitter124112963chitt_er
circler1136423circler
citer74827333ci_t_er
cither114616683ci_ther
citole8311503citole_
citoles9312553citoles
cittern9339143citt_ern
cotter84926673cott_er
cottier93814173cottier
critter94113033critt_er
cuittle946403cuittle_
cuittled1133993cuittled
cuittles1045903cuittles
cutler84718033_cutler
cutter84521003cutt_er
cuttle84113893cuttle_
cuttled10319933cuttled
cuttles93613923cuttles
dialer74315433di_aler
dialler848813dialler
dibbler124510283dibbler
dictier103411863dictier
diddler103511513diddler
dieter73516773diet_er
diether1147443diether
dirtier83312093dirtier
ditcher134012003ditcher
dither104417683di_ther
ditsier83010293ditsier
ditties83116983ditties
dittoed936733dittoed
ditzier17307963ditzier
dotter74419343dott_er
dottier83910923dottier
dottle74212503dottle_
dottles83912283dottles
either94517423ei_ther
emitter93211083emitt_er
epistler1044833epistler
fatter94523213fatt_er
fattier103513463fattier
fetter94120383fett_er
fettle93713123fettle_
fettled11378933fettled
fettles103912733fettles
fickler16348423fickler
fiddler12309953fiddler
filer85433003fi__ler
filler94623623fi_ller
filter94517633filt_er
fitted104716663fitt_ed
fitters104517753fitt_ers
flitter103413903flitt_er
footler104011873footler
fritter103912773fritt_er
gentler8378953gentler
getter74117613gett_er
giggler101029883giggler
giller74519733gi_ller
girdler9227313girdler
gitted84015053gitt_ed
gittern8337503gitt_ern
glitter84211803glitt_er
gritter83913353gritt_er
grittier9316263grittier
gutter73817713gutt_er
guttier83911103guttier
guttle74111973guttle_
guttled9378993guttled
guttlers9306933guttlers
guttles83011933guttles
hatter94724873hatt_er
higgler12369803higgler
hiller94421633hi_ller
hinter94021303hint_er
hitcher153712003hitcher
hither124417253hi_ther
hitters104717593hitt_ers
hostler103411023hostler
hotter94720083hott_er
hustler103410753hustler
idler65015663_i_dler
iller54821293_i_ller
inter55028493_int_er
istle52214713_istle_
istles62814983_istles
ither84617603_i_ther
ixtle12168013_ixtle_
ixtles13217063_ixtles
jettier14358693jettier
jilter133512513jilt_er
jingler154311093jingler
jitters144314473jitt_ers
jittery17346443jitt_ery
jostler14288223jostler
jotter134315633jott_er
kegeler1245493kegeler
kegler11398243k_egler
keister113011573keist_er
kelter103214383kelt_er
kibble143910953kibble_
kibbled16367983kibbled
kibbles153510253kibbles
kibitzer2342033kibitzer
kicker114116183ki_cker
kickier12349053kickier
kidder123811103ki_dder
kier86526813ki___er
kiester11329973kiester
killed113918773ki_lled
killers114215583ki_llers
kilted113613833kilt_ed
kilters113813603kilt_ers
kiltie103210963kiltie_
kilties113014143kilties
kinder113716843ki_nder
kindle114414233kindle_
kindled133410543kindled
kindlers13318483kindlers
kindles123614843kindles
kindlier1345763kindlier
kinglet123114043kinglet
kinglier1345633kinglier
kinkier10319433kinkier
kipper143414213ki_pper
kisser104212453ki_sser
kitchen16287683kitchen
kite85338243ki_t_e_
kited105120093ki_t_ed
kiters105218593ki_t_ers
kites95432543ki_t_es
kithe125917453ki_the_
kithed144613013ki_thed
kithes135016653ki_thes
kittened1334523kittened
kittens11347583kittens
kitting123214443kitting
kittling1336063kittling
kitty124614563kitt__y
klister113410643klist_er
kneeler11277573kneeler
knitted12337423knitt_ed
knitters12336623knitt_ers
knoller11285913knoller
knotter11317643knotter
knottier12203983knottier
kotower1434383kotower
krater104014313krat_er
kruller1145153kruller
latter65027893latt_er
letter63722583lett_er
libeler9219003libeler
lifter93814813lift_er
linter64625343lint_er
lintier73613803lintier
lister64527253list_er
liter54736343li_t_er
lither94520953li_ther
litten64014873litt_en
litterer82810173litterer
litters73422573litt_ers
littery103710493litt_ery
littlest8309243littlest
lotter64025603lott_er
matter84325343matt_er
mettle83815723mettle_
mettled103510543mettled
mettles94115023mettles
mickler153310233mickler
middler112712273middler
miler75733063mi__ler
miller84625413mi_ller
milter84921233milt_er
miltier93214963miltier
mingler104213843mingler
minter84425103mint_er
mintier93615993mintier
mister84728563mist_er
mistier93418713mistier
miter75734793mi_t_er
miterer92511333miterer
mither114218563mi_ther
mitier83620673mi_tier
mitten83914093mitt_en
mottle84116053mottle_
mottled10409973mottled
mottlers10388183mottlers
mottles93415803mottles
mutter84418883mutt_er
natter64420743natt_er
nattier73614623nattier
nestler73510453nestler
netter63722023nett_er
nettier74211813nettier
nettle64514583nettle_
nettled8339943nettled
nettlers8307513nettlers
nettles73214083nettles
nettlier864813nettlier
nibbler11379273nibbler
niftier10328713niftier
niggler93610293niggler
nimbler11358063nimbler
niter55028973ni_t_er
nutter63918053nutt_er
nuttier73112023nuttier
oiler54628283oi__ler
omitter9298503omitt_er
ostler63312193_ostler
otter54423973_ott_er
patter84628263patt_er
petter83924773pett_er
pettier94213613pettier
pettle84116053pettle_
pettled103611513pettled
pettles93916483pettles
piddler112911523piddler
pintle83818263pintle_
pintles94118723pintles
pitcher143813713pitcher
pithier123010293pithier
pitier84019823pi_tier
pitted94319593pitt_ed
potter83926983pott_er
pottier93516493pottier
pottle84416103pottle_
pottles93816983pottles
prattler10166343prattler
putter83921443putt_er
puttier93314503puttier
quitter162910753quitt_er
ratter64326313ratt_er
rattier74015593rattier
rattle64717613rattle_
rattled84012953rattled
rattlers83510293rattlers
rattles73217303rattles
riddler93411263riddler
riffler13328353riffler
rifler94014263ri_fler
rioter64817283riot_er
rippler113210103rippler
ritters74020623ritt_ers
ritzier16297203ritzier
rotter64325463rott_er
rustler73512343rustler
ruttier73412283ruttier
setter64023723sett_er
settle63915663settle_
settled83210873settled
settlers8289023settlers
settles73916003settles
settlor7314733settlor
shittier1137313shittier
shuttler1164903shuttler
sidler74716963si_dler
sifter94516233sift_er
siller64026063si_ller
siltier73413863siltier
simpler112910863simpler
sinter63625923sint_er
sister64421583sist_er
sitten64113823sitt_en
sitters74221553sitt_ers
sizzler15266863sizzler
skirter11338483skirt_er
skitters12349553skitt_ers
skittery15315103skitt_ery
slitter73615873slitt_er
slittier837003slittier
spitter94015183spitt_er
spittle937923spittle_
spittles1038333spittles
staler64025823_staler
stifler102911473stifler
stiller73414303stiller
styler94013303_styler
subtler92910843subtler
sutler63718393_sutler
taler56034863__taler
tatter64024573tatt_er
tattier74216243tattier
tattle64115653tattle_
tattled84311483tattled
tattlers8369693tattlers
tattles73616283tattles
tetter64322453tett_er
tickler133612653tickler
tiddler93110003tiddler
tiler56131023__tiler
tiller64222543ti_ller
tilter63417693tilt_er
tingler83613343tingler
tinkler113610543tinkler
tinter63923643tint_er
tippler11348343tippler
titer55430613ti_t_er
titfer9409523ti_tfer
tither94920283ti_ther
title54721073ti_tle_
titled73815003ti_tled
titles63719923ti_tles
titterer8268523titterer
titters74219623titt_ers
tittie63213153tittie_
titties73617363titties
titular737523titular
tootler73511123tootler
totter65021463tott_er
turtler72610323turtler
twitter10278093twitt_er
utter54218763_utt_er
vetter93417643vett_er
viler86324163vi__ler
vintner1034833vintner
vitamer1235473vitamer
vittae93911003vittae_
watter93221983watt_er
wattle94314213wattle_
wattled113610503wattled
wattles103814073wattles
wetter93919443wett_er
whistler1496313whistler
whitter139110893whitt_er
whittle13106103whittle_
whittled1594913whittled
whittlers1594333whittlers
whittles1496673whittles
wiftier13297733wiftier
wiggler123110763wiggler
willer94021063wi_ller
winter94222803wint_er
wintle94014603wintle_
wintled11339843wintled
wintles103414983wintles
wither124321353wi_ther
withier132910493withier
witted104216813witt_ed
yatter94116213yatt_er
zither183813083zi_ther

Search took 8 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.423422437.4
2DLD Change Limit1340274237.14018771.3
3Display Results4234230.1403021.4
 (SQL Overall)1786914237.70323197.6
 
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.