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

236 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
dured7502540(None) 
cured85932131cured
dared75935011dared
duded84417131duded
duked115218461duked
duped95118321duped
dure56341811dure_
dures65635921dures
durned84113171durned
lured65427491lured
mured85726701mured
acred87126352acred
adjured1634882adjured
adored84714242adored
aired66032922aired
aurei54821862aurei
aures55137092aures
bared85144482bared
bored85034302bored
bred75130972_bred
burd75534262bur_d
buret77444012buret
buried94822372buried
burked135220882burked
burled94825382burled
burned95818962burned
burped116215502burped
burred95820722burred
bused85624492bused
cared86050092cared
cered85227442cered
cored85044222cored
cred76530882_cred
cubed105519702cubed
cued76329562cu_ed
curbed114615872curbed
curd77634982cur_d
curded104217162curded
cure66149122cure_
curer75030752curer
cures75645432cures
curet75447642curet
curled95021652curled
curred94319262curred
cursed94321252cursed
curved124815222curved
dare55848862dare_
darer65230792darer
dares66146702dares
darked123919632darked
darned85018482darned
darted84620922darted
dated75530992dated
daubed104611782daubed
dauted84114932dauted
dawed106222812dawed
dazed165919362dazed
deed65340902d_eed
deked115718532deked
deled75326542deled
dere56845902dere_
deuced104112122deuced
dewed105020302dewed
diced95824682diced
died66137852d_ied
diked115024682diked
dined76431992dined
dire56644142dire_
direr64927072direr
dirked124912272dirked
dirled84514902dirled
dived106321372dived
doled75430912doled
domed95423262domed
doped95326712doped
dore56353302dore_
dosed76626912dosed
doted75227072doted
dourer74215272dourer
doused84821162doused
dowed104632612dowed
dozed165619352dozed
dread74419022d_read
dree56638322d_ree
dreed75222842dreed
dreg66821652d_reg
drek96321092d_rek
drew86221672d_rew
dried75321382dried
druid74111322druid
duad66521412du_ad
dubbed124113212dubbed
duce76933502duce_
duces86327472duces
ducked144718012ducked
ducted104012122ducted
dud56737592du__d
dude65629662dude_
dudes75424372dudes
due45249862du_e_
duel56729702du_el
dueled84813662dueled
dues56045502du_es
duet56446262du_et
dueted84113592dueted
duke95628102duke_
dukes105023472dukes
dulled84719422dulled
dumbed124012082dumbed
dumped123814492dumped
dune56137582dune_
dunes65332172dunes
dunged95414692dunged
dunked124315282dunked
dunned85015522dunned
dunted84718502dunted
dupe76630602dupe_
duper85519002duper
dupes86425932dupes
dupped124411642dupped
dura55232112dur_a
dural64923892dural
duras65727732duras
duress74712062duress
durn56127632dur_n
durns64819872durns
duro56228022dur_o
duroc84513142duroc
duros65422692duros
durr55624352dur_r
durra65315792durra
durrs65519992durrs
durst66125172durst
durum8513202durum
dusked124112512dusked
dusted83918372dusted
duvet9321872duvet
dyed96720762d_yed
dyked145310952dyked
eared65139502eared
educed10418852educed
endured93611212endured
enured73315332enured
erred65915672erred
fared95842342fared
fired94829742fired
fumed116118822fumed
furled104717052furled
furred104514432furred
fused94820442fused
fuzed185415252fuzed
gored75227082gored
gurged95513362gurged
guyed1049892guyed
gyred105114092gyred
hared95742182hared
hired95226262hired
hued86925852hu_ed
hurled104617452hurled
inured73114812inured
ired55131872_ired
juked175714072juked
jurel124516332jurel
juried144212442juried
loured74617402loured
lubed85319892lubed
luged74019092luged
lure45142462lure_
lurer54625312lurer
lures56138532lures
lurex124816732lurex
lurid64618972lurid
lurked114511972lurked
luted64826142luted
mired85729222mired
muled85824432muled
mure65941332mure_
mures75937222mures
murex145517172murex
murid84520582murid
mused85524582mused
muted85023382muted
nuked104014182nuked
nurd56224342nur_d
nurled74016232nurled
nursed74514672nursed
oared65030652oared
odored8399222odored
outed65429062outed
pared86946762pared
pored85234512pored
poured95116742poured
puked124716222puked
puled84926522puled
pure65543332pure_
puree74632842puree
pureed95017812pureed
purer75127902purer
purged104918262purged
purled94520752purled
purred94218072purred
pursed95220882pursed
quired163711952quired
rared65738322rared
red46755802__red
rued55729792ru_ed
ruled65822522ruled
sered65737292sered
shred98125612shred
sired66134282sired
sored66141782sored
soured74921862soured
sued56537932su_ed
surd56433812sur_d
sure45447412sure_
surer54833102surer
surfed103814462surfed
surged84118882surged
tared69340052tared
tired65228902tired
toured74216152toured
trued65117692trued
tubed85818042tubed
tuned64622312tuned
turd56027622tur_d
turfed103110962turfed
turned73914472turned
tyred95816432tyred
urd46427052_ur_d
urea46528062_urea
uredo65112992_uredo
urged75316032_urged
urped84615282_urped
used55722822_used
wared96339872wared
wired95327642wired

Search took 2 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.330541487.9
2DLD Change Limit538002361.57634137.1
3Display Results2362360.0802950.0
 (SQL Overall)1786912361.98689975.3
 
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.