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

149 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
closeted113561(None) 
closed95317962clos__ed
closet85226602closet__
closets94611602closet_s
closured11266352closured
clotted104011822clo_tted
clouted104212162clo_uted
clovered14187362clovered
colleted113011662colleted
corseted11311472corseted
cosseted1178342cosseted
costed95623112c_os_ted
coveted133011522c_oveted
accosted1345513accos_ted
allseed835953allse_ed
basseted1136743basseted
blasted104213473blas_ted
bloated104513433blo_ated
blotted103911833blo_tted
boosted104111983boos_ted
cacheted16148233cacheted
carpeted1338953carpeted
caseated11310713c_aseated
casketed1534953casketed
chested133811673ches_ted
chiseled1435883chiseled
cisted95217523c_is_ted
clashed133614013clas_hed
clasped123610443clas_ped
classed104113653clas_sed
clavered14187633clavered
cleated103417843cl_eated
cleeked14357733cl_eeked
clefted13326753cl_efted
cleped115114113cl__eped
clewed1225113203cl__ewed
cloaked14368543clo_aked
clobbered16164103clobbered
clocked164112833clo_cked
clogged12528653clo_gged
cloister1037093cloister
cloistered1344513cloistered
clomped14398973clo_mped
cloned94518803clo__ned
clonked14429563clo_nked
clopped143611523clo_pped
close76425223clos__e_
closefisted17101173closefisted
closely1237053close_ly
closeness1137613closeness
closeout1047333closeout
closer84918203clos__er
closers94415323close_rs
closes85425593clos__es
closest94312533close_st
closetful1452213closetful
closeting1236183closeting
closeup11113433close_up
closeups12102803closeups
closure9278483closure_
closures10228953closures
clothed134010283clo_thed
clotured11246163clotured
clouded11348833clo_uded
cloured103111543clo_ured
clouter93511693clo_uter
clowned13447733clo_wned
cloyed125111563clo__yed
cluster94013333clus_ter
clustered12186613clustered
clyster12317453clys_ter
coacted123611613c_oacted
coapted123911503c_oapted
coasted104015953c_oasted
coated94927043c_o_ated
cohered133514693c_ohered
cohosted1436133cohos_ted
coleseed1147403coleseed
collated113615063collated
collected1447973collected
colocated1439613colocated
competed154113593competed
compted143813523c_ompted
consented12311943consented
cooeed95917863c_ooe_ed
cooeyed1346893c_ooeyed
coopered133310933coopered
coopted123710763c_oopted
coroneted12278323coroneted
coset75748843c_oset__
cosets85824403c_oset_s
coshed124217543c_os_hed
coshered14610293c_oshered
cosied94819883c_os_ied
coster84331293c_os_ter
coted85033853c_o__ted
counted103815803c_ounted
courted103514923c_ourted
covered133315293c_overed
coveter122912063c_oveter
cowered133214653c_owered
cozened19349183c_ozened
creosoted1244043creosoted
crested103416533cres_ted
crocheted1745313crocheted
crocketed1845123crocketed
croqueted2143313croqueted
crossed105313893cros_sed
crosstied1245193crosstied
crusted103712753crus_ted
curveted1435293curveted
fleeted113310233fl_eeted
floated113312703flo_ated
floreated1346573floreated
flossed11388533flos_sed
flouted113210813flo_uted
flowered1546013flowered
frosted113211873fros_ted
ghosted1236273ghos_ted
gleeted9379323gl_eeted
gloated93511533glo_ated
globated1265753globated
glossed94410073glos_sed
glouted9429713glo_uted
glowered1345753glowered
gusseted1043553gusseted
hoseyed1436953_hoseyed
hosted105020343_hos_ted
lasted74323603_las_ted
listed74322833_lis_ted
lobated102610943_lobated
located103114183_located
lofted103811893_lo_fted
loosened945453loosened
looted74421113_lo_oted
lotted74222403_lo_tted
louted74920693_lo_uted
lowered112711913_lowered
lusted74319443_lus_ted
molested11178243molested
moseyed1336133_moseyed
plotted104612373plo_tted
posited10511493_posited
posted93722493_pos_ted
prosected14158633prosected
roosted83211883roos_ted
sleeted83113223sl_eeted
sloshed11329823slos_hed
slotted84613883slo_tted

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621497.11020557.2
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.59323533.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.