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

501 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
little6331216(None) 
kittle104012171kittle
littler7348551littler
littles73212781littles
tittle63613321tittle
vittle94711751vittle
battle85217862battle
belittle1044052belittle
bottle84916072bottle
brittle9168602brittle
cattle85118902cattle
citole8311502citole
cuittle946402cuittle
cuttle84113892cuttle
dottle74212502dottle
fettle93713122fettle
guttle74111972guttle
istle52214712_istle
ixtle12168012_ixtle
kettle104311612kettle
kirtle10309472kirtle
kittel10368872kittel
kittled12388192kittled
kittler11338162kittler
kittles113012492kittles
latte55426302latt_e
liable81415812liable
ligule74010832ligule
lintel64013992lintel
lisle53916722li_sle
listee64223062listee
listel64214742listel
lite47054542li_t_e
lithe84922012li_the
litre55421462li_tre
litten64014872litten
litter64324852litter
littlest8309242littlest
lotte54923852lott_e
lyttae994712lyttae
mettle83815722mettle
mottle84116052mottle
nettle64514582nettle
pettle84116052pettle
pintle83818262pintle
pottle84416102pottle
rattle64717612rattle
settle63915662settle
skittle1135532skittle
spittle937922spittle
tattle64115652tattle
title54721072ti_tle
tittie63213152tittie
tittles73413252tittles
vittae93911002vittae
vittled11347342vittled
vittles103211112vittles
wattle94314212wattle
whittle13106102whittle
wintle94014602wintle
aisle55223193ai_sle
alible8311973ali_ble
battled104213123battled
battler94113383battler
battles94517683battles
battue84311003battue
beetle8311673beetle
belittled1243033belittled
belittler1142493belittler
belittles1143873belittles
bible95119423bi_ble
bile66147183bi__le
bindle94516263bindle
birle75023633bi_rle
bistre83815023bistre
bitable11312203bitable
bite66547003bi_t_e
bitt65545813bitt__
bitted94418483bitted
bitten84715123bitten
bitter84622673bitter
bittier94211663bittier
bitts75022593bitt_s
bitty106119173bitt_y
blintze1833903blintze
blite76225353bli_t_e
blithe115810863bli_the
bottled104611233bottled
bottler94211883bottler
bottles94216273bottles
brattle9249253brattle
bristle91910103bristle
brittled11186093brittled
brittler10165983brittler
brittles10178653brittles
brittly12165973brittly
bustle84015483bustle
butle75023103_butle
butte74924293butt_e
cantle84522153cantle
castle84918963castle
cattie85221023cattie
cicale10314503cicale
circle1039703circle
citable11313463citable
cite65640343ci_t_e
citola838393citola
citoles9312553citoles
cottae84615703cottae
cuittled1133993cuittled
cuittles1045903cuittles
cuttled10319933cuttled
cuttles93613923cuttles
dartle73714833dartle
dibble114013843dibble
diddle94915213diddle
dimple113512793dimple
dindle84417223dindle
dingle84317073dingle
dipole91112853dipole
dite55547553di_t_e
ditties83116983ditties
ditto65315603ditt_o
dittoed936733dittoed
dittos74111973dittos
ditty95019293ditt_y
dottel73610893dottel
dottles83912283dottles
elite56230183eli_t_e
entitle7610293entitle
epistle957893epistle
fettled11378933fettled
fettles103912733fettles
fickle153912973fickle
fictile1238023fictile
fiddle113613383fiddle
file75446643fi__le
fille84327403fi_lle
fimble133611753fimble
finale94116763finale
fipple13329063fipple
fitly115114973fi_tly
fittable1337093fittable
fitted104716663fitted
fitter94120033fitter
fizzle17369713fizzle
flite85424963fli_t_e
flitted114011643flitted
flitter103413903flitter
footle93914383footle
futile93914953futile
fytte1138583fytt_e
gentle74014513gentle
giftee103512083giftee
giggle94313513giggle
girdle82110463girdle
gite55438613gi_t_e
gitted84015053gitted
gittin72910553gittin
glitter84211803glitter
gristle8169223gristle
guttae73210583guttae
guttled9378993guttled
guttler8369163guttler
guttles83011933guttles
hantle94318203hantle
higgle113811743higgle
hirple11158973hirple
hirsle9159573hirsle
hittable1336853hittable
hitter94419863hitter
hottie92514383hottie
hurtle93512943hurtle
hustle93113993hustle
idle55423763_i_dle
ingle64120433_ingle
inkle94515833_inkle
intitle7610583intitle
isle45121703_i_sle
istles62814983_istles
ixtles13217063_ixtles
jiggle153811993jiggle
jingle143815223jingle
jitter133314993jitter
jostle13319863jostle
justle133211583justle
kettles113411613kettles
kibble143910953kibble
kiltie103210963kiltie
kindle114414233kindle
kirtled12287033kirtled
kirtles11309663kirtles
kite85338233ki_t_e
kithe125917453ki_the
kitted115114833kitted
kitten104611483kitten
kitties113213623kitties
kittlest12297573kittlest
kitty124614563kitt_y
labile8315223labile
ladle66320443l_adle
laithly1335653laithly
lastly93310873lastly
late47560483l_at_e
lately93413843lately
lathe85626713l_athe
latke94817093l_atke
latten65018203latten
latter65027893latter
lattes65324203lattes
lattice938433lattice
lattin64316223lattin
lethe85717303l_ethe
letted74118543letted
letter63722583letter
lettuce943323lettuce
liaise6310693liaise
liane54720663li_ane
libel74116103libel_
libeled10249413libeled
libelee92510983libelee
libeler9219003libeler
libels85112693libels
librae84310173librae
lice66045063li__ce
lichee114017973lichee
lichtly15255523lichtly
licitly12276673licitly
lictor83610853lictor
lie38264523li___e
liefly1266363liefly
liege65314433li_ege
lierne638023lierne
lieve86315473li_eve
life75433733li__fe
lift76942723lift__
liftable1376863liftable
lifted104413523lifted
lifter93814813lifter
liftmen1234233liftmen
lifts85719063lift_s
ligase7259913ligase
ligate72519253ligate
lightly14369023lightly
ligula7359673ligula
ligulae8308753ligulae
ligules82210923ligules
ligure7279473ligure
likable13219413likable
like86040843li__ke
likely13328133likely
lilo46731563li__lo
lilt46349943li__lt
lilted73715373lilted
lilts55822803lilt_s
lily76730183li__ly
lime66244933li__me
limply133810033limply
limuli836343limuli
linable92214343linable
linage7713403linage
line46965573li__ne
lint416266233lint__
linted74021823linted
lintels73311163lintels
linter64625343linter
lintier73613803lintier
lintless82710013lintless
lintol6369473lintol
lintols7339553lintols
lints57137193lint_s
linty87126563lint_y
lipase8239103lipase
lipe66839733li__pe
lipide93511063lipide
lire47845293li__re
lisles63416283li_sles
list47055343list__
listable10810313listable
listed74322833listed
listees73416673listees
listels74212433listels
listen64816813listen
lister64527253lister
listless8269263listless
lists56628693list_s
lit39377313li_t__
litai55216363li_tai
litany939053litany
litas54923773li_tas
litchi1137893litchi
liter54736343li_ter
liters65429883liters
lithely1356643lithely
lither94520953lither
lithia939333lithia
lithic1139493lithic
litho86513783li_tho
lithoed1137833lithoed
lithos94212553lithos
litmus836323litmus
litotes7311183litotes
litotic939243litotic
litres65220393litres
lits46252493li_t_s
littered92511383littered
litterer82810173litterer
litters73422573litters
littery103710493littery
littlish1145043littlish
litu47631563li_t_u
livable122010323livable
live76540993li__ve
lively123310813lively
livre85613253li_vre
loathe94211383loathe
lobule82910063lobule
locale83915653locale
locule83412033locule
lotted74222403lotted
lotter64025603lotter
lottes65322753lottes
lotto55217573lott_o
lottos64613103lottos
lunule638433lunule
lustre64011683lustre
lute46341013l_ut_e
lytta888063lytt_a
lyttas985073lyttas
mantle84420923mantle
matte75626843matt_e
mettled103510543mettled
mettles94115023mettles
mickle143715133mickle
middle103414983middle
miggle104012113miggle
mile66352573mi__le
mille75029133mi_lle
mingle93518783mingle
mistitle1038523mistitle
mite66249413mi_t_e
mitre75522423mi_tre
mitt66145493mitt__
mitten83914093mitten
mitts75523753mitt_s
mizzle16279993mizzle
motile83818343motile
motte75526973mott_e
mottled10409973mottled
mottler94410343mottler
mottles93415803mottles
mutule8311423mutule
myrtle1135733myrtle
nestle63013953nestle
nettled8339943nettled
nettler7349503nettler
nettles73214083nettles
nettly9459453nettly
nibble103713283nibble
nickle123814483nickle
niggle83612823niggle
nimble103412943nimble
nipple103410373nipple
nite45943583ni_t_e
nitre57519683ni_tre
nitrile73011373nitrile
nittier73512243nittier
nitty85418313nitt_y
pattee84323383pattee
pattie84020963pattie
pestle83215843pestle
pettled103611503pettled
pettles93916483pettles
pickle144215653pickle
piddle103514913piddle
piffle14418233piffle
pile65649693pi__le
pilule8411123pilule
pimple123512963pimple
pinole83218783pinole
pintles94118723pintles
piste75824603pist_e
pistole92414313pistole
pitta75018693pitt_a
pittas86014523pittas
pitted94319593pitted
pizzle16279493pizzle
pliable111610323pliable
pottles93816983pottles
prattle9208833prattle
puttee85919723puttee
puttie84116303puttie
rattled84012953rattled
rattler74012743rattler
rattles73217303rattles
rattly94111543rattly
retile65929673retile
retitle73913093retitle
riddle83915713riddle
riffle124210233riffle
rifle85518333ri_fle
rile45650533ri__le
rille55728733ri_lle
rimple103814583rimple
ripple103413913ripple
rite45849453ri_t_e
ritter63822423ritter
rootle63214453rootle
rotte54625933rott_e
rustle63615413rustle
rutile65217683rutile
scuttle936463scuttle
settee63721023settee
settled83210873settled
settler73410653settler
settles73916003settles
shuttle1046103shuttle
sickle124418323sickle
sidle65124033si_dle
simile83115633simile
simple104315173simple
single74520603single
site47052413si_t_e
sitten64113823sitten
sitter63323383sitter
sixte126216583sixt_e
sizzle14309613sizzle
skittles1245763skittles
slitted83513313slitted
slitter73615873slitter
slittier837003slittier
slitty9329163slitt_y
spittles1038333spittles
stale55637103_stale
stele55026843_stele
stifle93611903stifle
stile54931573_stile
stole54928813_stole
style85519363_style
subtle82113433subtle
suttee63721543suttee
tale46154163__tale
tattie64817513tattie
tattled84311483tattled
tattler73112213tattler
tattles73616283tattles
tele45040873__tele
thistle10107803thistle
tickle124616743tickle
tile45451443__tile
tingle74319063tingle
tinkle103714453tinkle
tipple103411913tipple
tiptoe838283tiptoe
tithe85319703ti_the
titled73815003ti_tled
titles63719923ti_tles
titre54619393ti_tre
titter63421163titter
titties73617363titties
tittup834203tittup
titty85316653titt_y
tole46052903__tole
tootle62613813tootle
tule45735873__tule
turtle63213573turtle
twattle1064273twattle
utile54718933_utile
viable111613773viable
vile76139803vi__le
virile9313433virile
virtue9358673virtue
vitae84217633vi_tae
vital84819673vital_
vitals94514303vitals
vitta85015173vitt_a
vittate10409733vittate
wattled113610503wattled
wattles103814073wattles
whistle13107533whistle
whittled1594913whittled
whittler1495193whittler
whittles1496673whittles
widdle113814843widdle
wiggle113713013wiggle
wile75944373wi__le
wimble133211923wimble
wimple133611363wimple
windle104617953windle
winkle133812833winkle
wintled11339843wintled
wintles103414983wintles
wite75443273wi_t_e
withe115220233wi_the
witted104216813witted
wittier103910823wittier
wittily1336173wittily
wittol935923wittol
wittols1035733wittols
witty114717013witt_y
zizzle13247313zizzle

Search took 6 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.1431249587.4
2DLD Change Limit1127165015.59320153.0
3Display Results5015010.1563211.5
 (SQL Overall)1786915015.89230327.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.