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

174 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
closures1022895(None) 
closure9278481closure_
closured11266351closured
clotures10299021clotures
censures102211622censures
clonuses1057132clonuses
cloques18268562cloqu_es
closers94415322closer_s
closes85425592clos__es
cloture9238452cloture_
clotured11246162clotured
cloured103111542clo_ured
clours85215092clo_ur_s
colures9315142c_olures
cynosures1443872cynosures
enclosures1243542enclosures
exclosures1952382exclosures
inclosures1243092inclosures
allures72913113al_lures
assures7611403_assures
blouses94014463blo_uses
caesuras1055733caesuras
capsules1236623capsules
captures1239443captures
censure92310603censure_
censured11248913censured
censurer10228133censurer
censurers11256073censurers
censuses10187543censuses
cesuras958693c_esuras
chores114828023cho__res
choruses1339983choruses
choses115825133chos__es
chousers134610203chousers
chouses125117813cho_uses
choushes1637623choushes
claquers19226203claquers
claques18279013claqu_es
clashers134213993clashers
clashes124017283clas_hes
claspers124410913claspers
classers104111833classers
classes94717943clas_ses
clauses93813323cl_auses
cliques18309203cliqu_es
clobbers14397513clobbers
cloches144113713clo_ches
clockers16369813clockers
cloggers12437283cloggers
cloisters1137433cloisters
cloistress1242713cloistress
cloners94514823cloner_s
clones84526563clo__nes
clonus85212413clonu__s
cloque17288743cloqu_e_
close76425223clos__e_
closed95317963clos__ed
closeness1137613closeness
closer84918203clos__er
closest94312533clos__est
closet85226603clos__et
closeted1135613closeted
closets94611603clos_ets
closeups12102813closeups
closings11277673closings
closuring1255173closuring
clothes124513813clo_thes
clouded11348833clo_uded
clouds94612353clo_u_ds
cloughs13517053clo_ughs
clour76617283clo_ur__
clouted104212163clo_uted
clouter93511693clo_uter
clouters10399803clo_uters
clouts87017203clo_u_ts
clovered14187363clovered
clovers125114663clover_s
cloves114918823clo__ves
clowders14357473clowders
clozes174915563clo__zes
clues74623033cl__u_es
clusters102912403clusters
clysters13227843clysters
coenures1048683coenures
coheres122917693c_oheres
cohunes1249713c_ohunes
coinsures1136723coinsures
coleuses1039723coleuses
colludes11279223colludes
colobuses1346133colobuses
colossuses1243023colossuses
coloured1148313coloured
colourer1037563colourer
colourers1136473colourers
colours95913443colour_s
colure8314163c_olure_
composures1645143composures
conjures17119913conjures
consumes12310413consumes
cores76361853c_o__res
coses76949493c_os__es
coshers123618183c_oshers
coshes115022783c_os_hes
cosies84932153c_os_ies
cosines94122673c_osines
costers94128333c_osters
costrel9310373c_ostrel
costrels1038933c_ostrels
costumes1258013c_ostumes
coupes105022523c_o_upes
course85117783c_o_urse
courses94218893c_o_urses
courts84216173c_o_urts
coutures10311993coutures
crocuses1239023crocuses
crores86121163cro__res
crosiers103312063crosiers
crossers103912703crossers
crosses94220793cros_ses
croupes114613103cro_upes
croutes94815653cro_utes
cultures10310153cultures
cures75645433c___ures
cynosure1343553cynosure_
disclosures1453103disclosures
eclogues1144573eclogu_es
enclosure1143363enclosure_
ensures73315903_ensures
erasures837213erasures
exclosure1852493exclosure_
exposures1843483exposures
fissures1136573fissures
flexures1843423flexures
flossers11307863flossers
flosses103411973flos_ses
flossies112810123flossies
floured11289873flo_ured
flours94414053flo_ur_s
globules1135413globules
glossers9319053glossers
glosses84014123glos_ses
glossies93311253glossies
inclosure1143193inclosure_
insures73117263_insures
leisures836683leisures
lemures938793_lemures
ligures8269893_ligures
lobules92510813_lobules
locules92812603_locules
lores55045403_lo__res
losers65123583_loser_s
loses56742013_los__es
losses65925233_los_ses
lotuses74011253_lotuses
louies64525103_lo_uies
loupes84918053_lo_upes
loured74617403_lo_ured
lours55125293_lo_ur_s
louses66230283_lo_uses
louvres10356523_louvres
lures56138533_l__ures
lustres73013233_lustres
lususes736713_lususes
measures1038913measures
pleasures1145573pleasures
plosives1335893plosives
postures10313783_postures
procures1239213procures
rasures7312013_rasures
scissures1143323scissures
seisures838273seisures
sloshes103811803slos_hes
stoures74614163sto_ures
tonsures869133tonsures

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.406440125.6
2DLD Change Limit1461621746.98320931.1
3Display Results1741740.0632761.9
 (SQL Overall)1786911747.45223978.9
 
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.