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 “lists” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

241 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
lists5662869(None) 
cists76624531cists
fists85527541fists
gists66026191gists
hists86328371hists
kists95822121kists
lasts57731261lasts
lifts85719061lifts
lilts55822801lilts
lints57137191lints
lisps76913911lisps
list47055351list_
lits46252501li_ts
lusts55022801lusts
mists76633901mists
wists86728521wists
agists75713172agists
airts55626342airts
aits46355542ai_ts
alist56136782alist_
basts75936932basts
bests75932612bests
bints76130182bints
bises75435622bises
bisks115416802bisks
bits66148172bi_ts
bitts75022592bitts
blasts85116772blasts
bliss75616912blis_s
busts75227692busts
casts77237792casts
cist67244972cist_
cistus84611342cistus
clasts84817292clasts
clifts11519152clifts
costs77231142costs
cysts105912772cysts
deists74916432deists
delists84414172delists
diets66026642diets
dints67431312dints
dirts66824462dirts
discs85316262discs
disks105417472disks
diss56434492dis_s
dits56450532di_ts
dusts65923562dusts
easts57530322easts
elints65816422elints
enlists749392enlists
exists134710912exists
fasts86429682fasts
feists94915312feists
fests85828042fests
fiats85324482fiats
firsts95110922firsts
fiscs105311882fiscs
fist76248432fist_
fits76043472fi_ts
flints95617452flints
flirts95411482flirts
flits85625222fli_ts
foists95413982foists
gasts66628632gasts
gests66028812gests
gifts96214962gifts
gilts64924262gilts
girts65423622girts
gist56046772gist_
gits55744602gi_ts
glints75714212glints
glosts74513812glosts
grists74716482grists
gusts65722792gusts
heists96814632heists
hests85829932hests
hilts86924412hilts
hints87330622hints
hiss75629222his_s
hist76551552hist_
hits75545142hi_ts
hoists95516022hoists
holists104413962holists
hosts85526702hosts
isms66213472_isms
its35538842_i_ts
jests125922452jests
jilts124717412jilts
jisms14458002jisms
joists134711032joists
justs124918262justs
kilts95122192kilts
kiss85227412kis_s
kist86540812kist_
kits86441782ki_ts
lases54944762lases
lass47444542las_s
last46260322last_
lats45962702l_ats
leasts64616412leasts
leets54927122leets
lefts86517812lefts
legists899592legists
leses54930812leses
less45635102les_s
lest46956322lest_
lets47147942l_ets
liars54723162liars
libs66732772li_bs
lichts113712382lichts
licks115325392licks
lidos65219892lidos
lids56336472li_ds
liens56525502liens
liers55130402liers
lies46454202li_es
lieus56218482lieus
lift76942732lift_
lights104519912lights
likes96231902likes
lilos55821872lilos
lilt46349952lilt_
limas75627632limas
limbs96118942limbs
limes75636502limes
limits82514142limits
limns75718392limns
limos75320812limos
limps95522672limps
lines57054572lines
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059062li_ns
lint416266242lint_
linty87126562linty
lions55923212lions
lips67141452li_ps
liras56021982liras
lis37162282li__s
lisle53916722lisle
lisles63416282lisles
lisp68926892lis_p
listed74322832listed
listee64223062listee
listees73416672listees
listel64214742listel
listels74212432listels
listen64816812listen
listens74014132listens
lister64527252lister
listers74026532listers
lit39377322li_t_
litas54923772litas
lite47054552li_te
litu47631572li_tu
lives86133192lives
lofts85518362lofts
loots55431422loots
loses56742012loses
loss45337962los_s
lost47951492lost_
lots47652092l_ots
louts56330272louts
lunts55826902lunts
lust47442602lust_
lusty85417572lusty
lusus54813872lusus
lutists73810272lutists
lyrists1036962lyrists
lyses84518252lyses
lysis84511462lysis
maists85817572maists
masts77035762masts
midsts95510052midsts
milts75430712milts
mints76834042mints
mises74740562mises
misos76523292misos
miss65339432mis_s
mist66154542mist_
misty106120452misty
mitts75523752mitts
mosts76028542mosts
musts75527442musts
nests55728002nests
nisus56014392nisus
nits45741652ni_ts
oasts56529182oasts
odists749852odists
ousts55225702ousts
pasts75936502pasts
pests75933272pests
pints75936222pints
pisos76021062pisos
piss65033342pis_s
piste75824602piste
pistes85325632pistes
pits66348752pi_ts
posts75228782posts
relists73817052relists
rests54935872rests
rifts85718642rifts
riots54922012riots
rises55244042rises
risks94917062risks
risus54216392risus
rusts55026992rusts
shists96515112shists
sifts84918922sifts
silts55330822silts
sises55233832sises
sits45050212si_ts
slits56128852sli_ts
tests56530192tests
tilts55325612tilts
tints56030922tints
tits46145052ti_ts
twists9549752twists
vasts86423772vasts
vests85325982vests
visas84317652visas
vises84427772vises
visits9311422visits
vista85416602vista
vistas94513272vistas
waists97415452waists
wasts87433672wasts
wests85727002wests
whists124613812whists
wilts85023502wilts
wises85633192wises
wisps105214182wisps
wiss75630552wis_s
wist78049302wist_
wits76044882wi_ts
wrists95415642wrists
xysts15558122xysts
zests145419742zests
zits136030302zi_ts

Search took 3 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 Filter178691538000.343520965.0
2DLD Change Limit538002411.61033416.1
3Display Results2412410.0633825.4
 (SQL Overall)1786912412.01688636.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.