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

213 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
cists7662453(None) 
casts77237791casts
cist67244961cist_
cistus84611341cistus
costs77231141costs
cysts105912771cysts
fists85527541fists
gists66026191gists
hists86328371hists
kists95822111kists
lists56628691lists
mists76633901mists
wists86728521wists
agists75713172agists
airts55626342airts
aits46355532ai_ts
basts75936932basts
bests75932612bests
bints76130182bints
bises75435622bises
bisks115416802bisks
bits66148162bi_ts
bitts75022592bitts
busts75227692busts
cants77036942cants
carts78946292carts
casas75327842casas
cases75048382cases
casks115720062casks
cast67159902cast_
caste75932362caste
castes85631862castes
casus76419252casus
cats66356342c_ats
celts75325782celts
cents74730332cents
cess65326052ces_s
cesta75419482cesta
cestas85018542cestas
cesti75217422cesti
cestos84718092cestos
cestus84412912cestus
chats105730092chats
chests114916262chests
chints115117832chints
chits105424572chits
cigs75625102ci_gs
cines75239682cines
cions75222852cions
cires74932912cires
cis57748032ci__s
cisco95112132cisco
ciscos104711132ciscos
cissy104811072cissy
cisted95217522cisted
cite65640342ci_te
cites74435592cites
city95122622ci_ty
civets115212542civets
clasts84817292clasts
clifts11519152clifts
clots75627642clots
coasts85719142coasts
coats75635002coats
colts76633292colts
coots75636842coots
coses76949492coses
cosets85824402cosets
coss66143492cos_s
cost68057942cost_
costa75523732costa
cots68054842c_ots
crests85218702crests
crises84529432crises
crisis83716342crisis
crisps104411512crisps
crista8311802crista
crits75527572crits
crusts84916542crusts
cubists11359022cubists
cults75022552cults
cunts76125122cunts
cusks114916052cusks
cusps94913672cusps
cuss65430612cus_s
custos84014312custos
cuts65841152c_uts
cyst96322812cyst_
deists74916432deists
diets66026642diets
dints67431312dints
dirts66824462dirts
discs85316262discs
disks105417472disks
diss56434482dis_s
dits56450522di_ts
dusts65923562dusts
easts57530322easts
exists134710912exists
fasts86429682fasts
feists94915312feists
fests85828042fests
fiats85324482fiats
firsts95110922firsts
fiscs105311882fiscs
fist76248422fist_
fits76043462fi_ts
foists95413982foists
gasts66628632gasts
gests66028812gests
gifts96214962gifts
gilts64924262gilts
girts65423622girts
gist56046762gist_
gits55744592gi_ts
grists74716482grists
gusts65722792gusts
heists96814632heists
hests85829932hests
hilts86924412hilts
hints87330622hints
hiss75629212his_s
hist76551542hist_
hits75545132hi_ts
hoists95516022hoists
hosts85526702hosts
isms66213472_isms
its35538832_i_ts
jests125922452jests
jilts124717412jilts
jisms14458002jisms
joists134711032joists
justs124918262justs
kilts95122182kilts
kiss85227402kis_s
kist86540802kist_
kits86441772ki_ts
lasts57731262lasts
lifts85719062lifts
lilts55822802lilts
lints57137192lints
lisps76913912lisps
list47055342list_
lits46252492li_ts
lusts55022802lusts
maists85817572maists
masts77035762masts
midsts95510052midsts
milts75430712milts
mints76834042mints
mises74740562mises
misos76523292misos
miss65339422mis_s
mist66154532mist_
misty106120452misty
mitts75523752mitts
mosts76028542mosts
musts75527442musts
nests55728002nests
nisus56014392nisus
nits45741642ni_ts
oasts56529182oasts
odists749852odists
ousts55225702ousts
pasts75936502pasts
pests75933272pests
pints75936222pints
pisos76021062pisos
piss65033332pis_s
piste75824602piste
pistes85325632pistes
pits66348742pi_ts
posts75228782posts
racists92613322racists
rests54935872rests
rifts85718642rifts
riots54922012riots
rises55244042rises
risks94917062risks
risus54216392risus
rusts55026992rusts
schists1248542schists
shists96515112shists
sifts84918922sifts
silts55330822silts
sises55233832sises
sits45050202si_ts
tests56530192tests
tilts55325612tilts
tints56030922tints
tits46145042ti_ts
twists9549752twists
vasts86423772vasts
vests85325982vests
visas84317652visas
vises84427772vises
visits9311422visits
vista85416602vista
vistas94513272vistas
waists97415452waists
wasts87433672wasts
wests85727002wests
whists124613812whists
wilts85023502wilts
wises85633192wises
wisps105214182wisps
wiss75630542wis_s
wist78049292wist_
wits76044872wi_ts
wrists95415642wrists
xysts15558122xysts
zests145419742zests
zits136030292zi_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.330541487.9
2DLD Change Limit538002131.70031647.1
3Display Results2132130.0633381.0
 (SQL Overall)1786912132.09385375.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.