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

141 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
opted8491427(None) 
oped76230151op_ed
outed65429061outed
acted88521732acted
adopted1136252adopted
anted66328242anted
aped78538152ap_ed
apter76120202apter
bated85935532bated
boated94221972boated
bolted94617802bolted
booted94822732booted
bopped134413402bopped
cited84421952cited
coapted123911502coapted
coated94927042coated
compted143813522compted
coopted123710762coopted
coped105036842cop_ed
copied114618562copied
copped135221252copped
copter109822012copter
costed95623112costed
coted85033852coted
dated75530992dated
doated84118182doated
doited85016632doited
doped95326712dop_ed
doted75227072doted
dotted84717522dotted
fated95632132fated
feted94420932feted
footed104418622footed
fopped144012672fopped
gated75329772gated
hated95734022hated
hooted104422662hooted
hoped115628182hop_ed
hopped144318112hopped
hosted105020342hosted
hotted104319942hotted
jolted143510632jolted
jotted143615172jotted
kited105120092kited
lated65240672lated
lofted103811892lofted
looted74421112looted
loped85128332lop_ed
lopped114218622lopped
lotted74222402lotted
louted74920692louted
luted64826142luted
mated85537782mated
meted85424432meted
moated94819002moated
molted94217472molted
mooted94120372mooted
moped105424732mop_ed
mopped134114322mopped
muted85023382muted
noted65123842noted
oared65030652oared
oaten55222402oaten
oater55433732oater
octad81510652octad
octet7324062octet
offed12359162offed
often84611412often
ofter84116872ofter
ogled75915962ogled
ohed87825182o_hed
oiled64429472oiled
oohed94214212oohed
ootid61416702ootid
oozed154214262oozed
ope56845242op_e_
open66427002op_en
opened94311862opened
opes65942612op_es
opiated1039482opiated
opined95113852opined
opt57545542opt__
optic93715182optic
opts68124742opt_s
orated74221502orated
orbed85516192orbed
otter54423972otter
ousted73720582ousted
outer55633302outer
outled74020342outled
owed86833872o_wed
owned95113232owned
oxter123414092oxter
pated85237842pated
ped66751522_p_ed
peed76239182_peed
pied75035362_pied
pled75231432_pled
poked125425392poked
poled84934842poled
pooed85226242pooed
popped104117812popped
pored85234512pored
ported94223242ported
posed85828412posed
posted93722492posted
potted94624012potted
pouted94021392pouted
poxed154817862poxed
rated65441382rated
rooted75424002rooted
roped84630802rop_ed
rotted74524432rotted
routed75624332routed
sated66238532sated
sited65130742sited
sooted73922592sooted
sopited104211062sopited
sopped114819902sopped
sorted74523712sorted
sotted74121402sotted
spaed85522272spaed
sped76031492sp_ed
speed85526622speed
spied85427712spied
spited94820442spited
spued84918472spued
ted46446562__ted
toited74016752toited
tooted74620122tooted
toped85631312top_ed
topped114617722topped
toted64929482toted
totted74319952totted
touted74419742touted
upped103715162upped
voted93919142voted
wited94727142wited
wonted103213282wonted
wotted104115712wotted
wyted12529472wyted

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.296603685.8
2DLD Change Limit538001411.54634799.5
3Display Results1411410.0502820.0
 (SQL Overall)1786911411.89294445.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.