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

312 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
costs7723114(None) 
casts77237791casts
cists76624531cists
coasts85719141coasts
coats75635001coats
colts76633291colts
coots75636841coots
coses76949491coses
cosets85824401cosets
coss66143491cos_s
cost68057941cost_
costa75523731costa
cots68054841co_ts
cysts105912771cysts
hosts85526701hosts
mosts76028541mosts
posts75228781posts
accosts11107992accosts
basts75936932basts
bests75932612bests
boasts85017922boasts
boats75635152boats
bolts76232112bolts
boosts86115012boosts
boots75837972boots
borts76735452borts
bosks115218852bosks
boss65938342bos_s
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
busts75227692busts
cants77036942cants
carts78946292carts
casas75327842casas
cases75048382cases
casks115720062casks
cast67159902cast_
caste75932362caste
castes85631862castes
casus76419252casus
cats66356342c_ats
celts75325782celts
cents74730332cents
cess65326052ces_s
cesta75419482cesta
cestas85018542cestas
cesti75217422cesti
cestos84718092cestos
cestus84412912cestus
chats105730092chats
chests114916262chests
chits105424572chits
choses115825132choses
chotts113610992chotts
cist67244962cist_
cistus84611342cistus
clasts84817292clasts
cloots85113692cloots
closes85425592closes
closets94611602closets
clots75627642clots
clouts87017202clouts
coacts105314332coacts
coals76129602coals
coapts104614012coapts
coast75236272coast_
coat67558352coat_
coati75624642coati
coatis85122602coatis
cobbs115013992cobbs
cobs87043142co_bs
cocas95926572cocas
cocks135227162cocks
cocos95624692cocos
codas84724242codas
codes86247292codes
cods76848102co_ds
coeds85920162coeds
coffs134916302coffs
coft97939682coft_
cogs77340032co_gs
cohos105921852cohos
cohosts12398812cohosts
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
coitus8511892coitus
cokes115537192cokes
colas75436772colas
colds85726972colds
coles76055062coles
cols66553082co_ls
colt67158242colt_
comas95833002comas
combs116122962combs
comes97246992comes
comets105823582comets
comps115526052comps
compts125216652compts
comte96125472comte
comtes106222812comtes
cones76457422cones
conks115525702conks
conns75024232conns
cons66057692co_ns
conte76633202conte
contes84432912contes
conto76027172conto
contos84923232contos
conus76726532conus
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coons76737282coons
coops96229642coops
coopts105814582coopts
coos67456492co_os
coot67860382coot_
copes97747102copes
cops86751372co_ps
copses104922472copses
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442co_rs
corses84433462corses
corsets94819802corsets
cos510270392co__s
cosec96320182cosec
cosecs105015212cosecs
coset75748842coset
cosey106226712cosey
coseys115215812coseys
cosh96127622cos_h
coshes115022782coshes
cosie74728262cosie
cosies84932152cosies
cosmos10311752cosmos
cossets95014282cossets
costae85319682costae
costal85419512costal
costar85518612costar
costars94218012costars
costed95623112costed
coster84331292coster
costers94128332costers
costly114012332costly
cosy97232702cos_y
cot510483222co_t_
cote66648732co_te
cotes76347842cotes
cotta75818572cotta
cottas84615572cottas
counts84618272counts
coups95522472coups
courts84216172courts
couth106122492couth
couths115715412couths
coves105539172coves
covets114819642covets
cowls106922212cowls
cows97046642co_ws
coxes145430862coxes
coys97537242co_ys
cozes166033242cozes
crests85218702crests
crits75527572crits
crofts114910592crofts
cross75124502cros_s
crusts84916542crusts
cults75022552cults
cunts76125122cunts
cusks114916052cusks
cusps94913672cusps
cuss65430612cus_s
custos84014312custos
cuts65841152c_uts
cyst96322812cyst_
doats65224882doats
doits66223672doits
dolts65626312dolts
doses65938502doses
doss56235042dos_s
dost57248352dost_
dots55647662do_ts
dusts65923562dusts
easts57530322easts
fasts86429682fasts
fests85828042fests
fists85527542fists
foists95413982foists
fonts86124752fonts
foots85528282foots
forts86034452forts
foss76431642fos_s
frosts94214622frosts
gasts66628632gasts
gests66028812gests
ghosts10489272ghosts
gists66026192gists
glosts74513812glosts
goats65527302goats
gouts64826172gouts
gusts65722792gusts
hests85829932hests
hists86328372hists
hoists95516022hoists
holts85627912holts
hoots84830252hoots
horsts95817512horsts
hoses85443182hoses
host77852832host_
hosta85917832hosta
hostas94515832hostas
hots78349332ho_ts
jests125922452jests
joists134711032joists
jolts125018882jolts
joss115925592jos_s
jots116336142jo_ts
jousts135011272jousts
justs124918262justs
kists95822112kists
koss85224812kos_s
lasts57731262lasts
lists56628692lists
lofts85518362lofts
loots55431422loots
loses56742012loses
loss45337962los_s
lost47951492lost_
lots47652092lo_ts
louts56330272louts
lusts55022802lusts
masts77035762masts
mists76633902mists
moats75827642moats
molts76032092molts
moots75831662moots
morts75533562morts
mosks116117002mosks
moss67641032mos_s
most66554202most_
moste75925082moste
mots66853162mo_ts
motts76527002motts
musts75527442musts
nests55728002nests
noses55435642noses
nowts86915862nowts
oasts56529182oasts
oats46554212_oats
oots46446442_oots
opts68124742_opts
orts46538332_orts
oses46641512_oses
ousts55225702ousts
outs45746962_outs
pasts75936502pasts
pests75933272pests
poets76024442poets
ports75934592ports
poses74642762poses
posits85718712posits
post67953362post_
pots66452362po_ts
pouts75530322pouts
rests54935872rests
roasts64915412roasts
roosts64916322roosts
roots55933672roots
roses56445772roses
rosets65819952rosets
rots46454092ro_ts
rousts617016722rousts
routs57133412routs
rusts55026992rusts
scoots85315942scoots
scots74025912sco_ts
scouts84817942scouts
softs85019232softs
soots55536212soots
sorts54536662sorts
sots45552452so_ts
tests56530192tests
toasts65914992toasts
tofts84919242tofts
toits55327472toits
toots55331872toots
torts56138122torts
toss45637972tos_s
tost48351922tost_
tots46654122to_ts
touts54830392touts
vasts86423772vasts
vests85325982vests
volts85421292volts
wasts87433672wasts
wests85727002wests
wists86728522wists
wonts87621542wonts
worsts96014332worsts
worts88631182worts
wost76544362wost_
wots76342892wo_ts
xysts15558122xysts
zests145419742zests

Search took 4 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.610292936.1
2DLD Change Limit538003122.89018615.9
3Display Results3123120.1701835.3
 (SQL Overall)1786913123.67048689.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.