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

134 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
closured1126635(None) 
closure9278471closure_
closures10228941closures
clotured11246161clotured
cloured103111541clo_ured
censured11248912censured
closed95317962clos__ed
closeted1135612closeted
cloture9238452cloture_
clotures10299022clotures
clouded11348832clo_uded
clouted104212162clo_uted
clovered14187362clovered
coloured1148302coloured
floured11289872flo_ured
loured74617402_lo_ured
allured8299173al_lured
assured858373_assured
bloodred1234083bloodred
bloused104310643blo_used
capsuled1334533capsuled
captured1336563captured
censored11197953censored
censure92310603censure_
censurer10228133censurer
censures102211623censures
censused11184973censused
choired13349343cho_ired
chored125321883cho__red
chorused1446133chorused
choused135012463cho_used
clamored1336943clamored
clamoured1444063clamoured
clashed133614013clas_hed
clasped123610443clas_ped
classed104113653clas_sed
clavered14187633clavered
cleared103612463cl_eared
cliqued19266683cliqu_ed
cloaked14368543clo_aked
clobbered16164103clobbered
clocked164112833clo_cked
clogged12528653clo_gged
cloistered1344513cloistered
clomped14398973clo_mped
cloned94518803clo__ned
clonked14429563clo_nked
clonuses1057133clonuses
clopped143611523clo_pped
cloque17288743cloqu_e_
cloques18268563cloqu_es
close76425223clos__e_
closer84918203clos__er
closers94415313closer_s
closes85425593clos__es
closet85226603clos__et
closuring1255173closuring
clothed134010283clo_thed
clotted104011823clo_tted
cloud86716423clo_u__d
clour76617283clo_ur__
clours85215083clo_ur_s
clouter93511683clo_uter
clowned13447723clo_wned
cloyed125111563clo__yed
clued84917683cl__u_ed
clustered12186603clustered
cohered133514693c_ohered
coinsured1245503coinsured
collared113211143collared
colluded12296453colluded
colorbred1443953colorbred
colored10313473c_olored
colourer1037553colourer
colure8314153c_olure_
colures9315133c_olures
conjured18117893conjured
consumed1337923consumed
coopered133310933coopered
cored85044223c_o__red
coshed124217543c_os_hed
coshered14610293c_oshered
cosied94819883c_os_ied
costed95623113c_os_ted
costrel9310363c_ostrel
costumed1365033c_ostumed
couped115019313c_o_uped
coursed104113603c_o_ursed
courted103514913c_o_urted
covered133315293c_overed
cowered133214643c_owered
crossbred1444093crossbred
crossed105313893cros_sed
cultured1137233cultured
cured85932133c___ured
cynosure1343543cynosure_
cynosures1443863cynosures
enclosure1143363enclosure_
enclosures1243543enclosures
ensured83512943_ensured
exclosure1852493exclosure_
exclosures1952383exclosures
fissured1235183fissured
floored11268683flo_ored
flossed11388533flos_sed
flouted113210813flo_uted
flowered1546013flowered
glossed94410073glos_sed
glouted9429713glo_uted
glowered1345753glowered
inclosure1143183inclosure_
inclosures1243083inclosures
insured83714253_insured
leisured934763leisured
loculed10317653_loculed
louped95316383_lo_uped
loused74822913_lo_used
louted74920693_lo_uted
louvred11354663_louvred
lowbred13225363_lowbred
lowered112711913_lowered
lured65427493_l__ured
lustred8359053_lustred
measured1136463measured
pleasured1244193pleasured
postured1139493_postured
poured95116743_po_ured
procured1336603procured
scoured103811153sco_ured
sloshed11329823slos_hed
soured74921863_so_ured
tonsured976383tonsured
toured74216153_to_ured
unsoured9310053unsoured

Search took 10 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.220812231.8
2DLD Change Limit1461621348.93616356.5
3Display Results1341340.0462913.0
 (SQL Overall)1786911349.20219418.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.