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

176 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
close7642522(None) 
chose105925401chose
clone75728161clone
closed95317961closed
closer84918201closer
closes85425591closes
closet85226601closet
clove105619441clove
cloze165517541cloze
lose45144581_lose
aldose7311092aldose
aloe45540192alo_e
aloes54933672aloes
alone55732962alone
arose55832082arose
blase75524232blase
bloke114316632bloke
blouse84714722blouse
brose75227032brose
callose9313662callose
calos74431902calos_
carse74934332carse
case65848082c_ase
cause75225352cause
cease75227652cease
cense75121402cense
chase105127122chase
choke145118022choke
choose115116142choose
chore105126762chore
chosen116014132chosen
choses115825132choses
chouse116017562chouse
chowse144711752chowse
clade85821012clade
clash106219032clash
clasp95517192clasp
class75525482class
clast76030582clast
clause84311502clause
clave105420152clave
cleome1039082cleome
clepe94617382clepe
clime95720892clime
cline76428532cline
cloak115214012cloak
cloche134312372cloche
clock134917982clock
clod76124612clo_d
clods85320862clods
clog76123242clo_g
clogs85519552clogs
clomb115714702clomb
clomp115615702clomp
clon66232482clo_n
cloned94518802cloned
cloner84418092cloner
clones84526562clones
clonk114417442clonk
clons75228132clons
cloot76127052cloot
clop86929892clo_p
clops95924852clops
cloque17288742cloque
closely1237052closely
closers94415322closers
closest94312532closest
closets94611602closets
closeup11113432closeup
closure9278482closure
clot66542422clo_t
cloth105817542cloth
clothe114712992clothe
clots75627642clots
cloud86716422cloud
clour76617282clour
clout75330462clout
cloven114211512cloven
clover114617122clover
cloves114918822cloves
clown105214732clown
cloy96623832clo_y
cloyed125111562cloyed
cloys104916942cloys
clozes174915562clozes
clue65324532cl_ue
clues74623032clues
code77347732c_ode
coke107038382c_oke
cole66956112c_ole
coles76055062coles
colone85425002colone
cols66553082cols_
come87547702c_ome
comose105016842comose
cone67256962c_one
cooee74531022cooee
coos67456492coos_
cope86847382c_ope
copse95623922copse
core67263112c_ore
corse75036182corse
cos510270392c_os_
cosec96320182c_osec
coses76949492c_oses
coset75748842c_oset
cosey106226712c_osey
cosh96127622c_osh
cosie74728262c_osie
coss66143492c_oss
cost68057942c_ost
cosy97232702c_osy
cote66648732c_ote
cove95837072c_ove
crone75231332crone
crore74922872crore
cross75124502cross
crosse85216302crosse
crouse84619362crouse
croze164719452croze
cruse75726102cruse
curse75829142curse
cymose13429652cymose
dose56442432_dose
elope75219342elope
else45923082el_se
enclose999992enclose
erose55727272erose
filose96112502filose
floe76129772flo_e
floes85528142floes
floss85118262floss
globe84917012globe
gloss64319622gloss
glost65422932glost
glove94516292glove
gloze154815982gloze
goose65925902goose
hose76547242_hose
inclose9910222inclose
lase46148512_lase
lobe65535362_lobe
lode56240112_lode
loge56837192_loge
lone45849132_lone
loose56627682loose
lope65941922_lope
lore45850352_lore
losel54419422_losel
loser54728672_loser
loses56742012_loses
loss45337962_loss
lost47951492_lost
louse56131012_louse
love75234762_love
lowe75435312_lowe
lowse87219902_lowse
lyse76320592_lyse
moose76327192moose
noose55624062noose
nose46739362_nose
ose38147342__ose
pilose84514242pilose
pose66441732_pose
prose75835122prose
roose56127092roose
rose46148902_rose
sloe45534952slo_e
sloes54728872sloes
slope75823562slope
slosh84514482slosh
those85218142those
unclose91111642unclose
whose114914532whose
xylose1636762xylose
zlote143912942zlote

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 Filter178691538000.406440125.6
2DLD Change Limit538001764.98310796.7
3Display Results1761760.266661.7
 (SQL Overall)1786911765.65531598.8
 
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.