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

130 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
closed9531796(None) 
cloned94518801cloned
close76425221close_
closer84918201closer
closes85425591closes
closet85226601closet
cloyed125111561cloyed
bloused104310642bloused
blowed125016692blowed
blowsed13449022blowsed
cased86032412c_ased
caused95117042caused
ceased94920782ceased
censed94016322censed
cessed94615612cessed
chased125019292chased
choked164914792choked
chored125321882chored
chose105925402chose_
chosen116014132chosen
choses115825122choses
choused135012462choused
chowed154914642chowed
chowsed16478602chowsed
clashed133614012clashed
clasped123610442clasped
classed104113652classed
clawed125115072clawed
clayed125013042clayed
cleped115114112cleped
clewed1225113202clewed
cloaked14368542cloaked
clocked164112832clocked
clod76124612clo__d
clogged12528652clogged
clomped14398972clomped
clone75728162clone_
cloner84418092cloner
clones84526562clones
clonked14429562clonked
clopped143611522clopped
closely1237052closely
closers94415312closers
closest94312532closest
closeted1135612closeted
closets94611602closets
closeup11113432closeup
closured11266352closured
clothed134010282clothed
clotted104011822clotted
cloud86716422clo_ud
clouded11348832clouded
cloured103111542cloured
clouted104212162clouted
clove105619442clove_
cloven114211512cloven
clover114617122clover
cloves114918822cloves
clowned13447722clowned
cloze165517542cloze_
clozes174915562clozes
clued84917682cl_ued
coded95433182c_oded
coed77140542c_o_ed
coked124730692c_oked
coled85540752c_oled
colored10313472colored
coned86040052c_oned
cooed84534342c_ooed
cooeed95917862cooeed
cooked135921362cooked
cooled95224582cooled
cooped114821602cooped
coped105036842c_oped
cored85044222c_ored
cosec96320182c_osec
coses76949492c_oses
coset75748842c_oset
cosey106226712c_osey
coshed124217542c_oshed
cosied94819882c_osied
costed95623112c_osted
coted85033852c_oted
coved115027372c_oved
cowed115637842c_owed
coxed154322812c_oxed
coyed114623802c_oyed
crossed105313892crossed
crowed124717292crowed
cursed94321252cursed
cussed94917122cussed
dosed76626912_dosed
eloped95914142eloped
enclosed1198252enclosed
flossed11388532flossed
flowed133513762flowed
globed104811762globed
glossed94410072glossed
gloved114811872gloved
glowed114913832glowed
glozed173711222glozed
goosed86817032goosed
hosed95830982_hosed
inclosed1197612inclosed
lased65132342_lased
lobed86022132_lobed
looed64626132_looed
loosed75520892loosed
loped85128332_loped
lose45144582_lose_
losel54419422_losel
loser54728672_loser
loses56742012_loses
loused74822912_loused
loved95021362_loved
lowed95233902_lowed
loxed135017052_loxed
lysed95011562_lysed
noosed75018012noosed
nosed65524552_nosed
plowed124213202plowed
ployed124310562ployed
posed85828412_posed
prosed94921092prosed
roosed75621592roosed
rosed65930342_rosed
sloped94216852sloped
sloshed11329822sloshed
slowed104617072slowed
unclosed111010502unclosed

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511302.54632423.8
3Display Results1301300.0304333.3
 (SQL Overall)1786911302.68666526.8
 
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.