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

153 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
wonted10321328(None) 
wanted104319721wanted
wonned104012061wonned
wotted104115711wotted
anted66328242_anted
boated94221972boated
bolted94617802bolted
bonded104719952bonded
boned85133242bon_ed
bonged105719602bonged
bonked135517312bonked
booted94822732booted
bunted95219182bunted
canted94825782canted
coated94927042coated
coned86040052con_ed
conked135019112conked
conned95119702conned
conte76633202conte_
contend103511892contend
contes84432912contes
costed95623112costed
coted85033852co_ted
counted103815802counted
dented84120512dented
dinted84419842dinted
doated84118182doated
doited85016632doited
donated93513862donated
donned85015742donned
doted75227072do_ted
dotted84717522dotted
dunted84718502dunted
fonded115717042fonded
footed104418622footed
fronted114011272fronted
gonged97115912gonged
hanted104124312hanted
hented104218752hented
hinted104318322hinted
honed95332262hon_ed
honied104818392honied
honked144517912honked
hooted104422662hooted
hosted105020342hosted
hotted104319942hotted
hunted104417012hunted
jointed15378502jointed
jolted143510632jolted
jotted143615172jotted
konked104010582konked
linted74021822linted
lofted103811892lofted
longed87121372longed
looted74421112looted
lotted74222402lotted
louted74920692louted
lunted74517522lunted
minted94220582minted
moated94819002moated
molted94217472molted
monied94319462monied
monte75829772monte_
montes84226932montes
mooted94120372mooted
mounted103611532mounted
noted65123842no_ted
opted84914272_opted
outed65429062_outed
owned95113232own_ed
panted95024822panted
pointed103813982pointed
ponced114314812ponced
ponded105218772ponded
ponged105619352ponged
ponied94920702ponied
pontes83627852pontes
ported94223242ported
posted93722492posted
potted94624012potted
pouted94021392pouted
punted94618712punted
ranted74324702ranted
rented74426592rented
rooted75424002rooted
rotted74524432rotted
routed75624332routed
sooted73922592sooted
sorted74523712sorted
sotted74121402sotted
swotted11398712swotted
tented74221002tented
tinted74419532tinted
toited74016752toited
toned65435342ton_ed
tonged86518902tonged
tooted74620122tooted
toted64929482to_ted
totted74319952totted
touted74419742touted
unwonted12248642unwonted
vented104617922vented
voted93919142vo_ted
wafted134012142wafted
waited103819772waited
waned95831782wan_ed
wanked144517152wanked
wanned104318012wanned
wanter94423052wanter
warted104223232warted
wasted104423022wasted
weeted103913792weeted
welted103715822welted
wended113616152wended
wetted103717022wetted
whited134814082whited
wilted103915712wilted
winced124415342winced
winded114918212winded
wined94434182win_ed
winged114620832winged
winked144018602winked
winned104017012winned
winter94222802winter
wintled11339842wintled
wisted104120272wisted
wited94727142w_ited
witted104216812witted
woaded115211602woaded
wolfed13428012wolfed
wombed14419232wombed
wonder103617812wonder
wonner95114442wonner
wont75842502wont__
wontedly1544252wontedly
wonton93410962wonton
wonts87621542wont_s
wooded114213682wooded
wooed94419872wo_oed
woofed134511202woofed
wooled103715502wooled
worded114316622worded
worked145314702worked
wormed124314302wormed
worsted1138012worsted
worthed1437872worthed
wounded12329762wounded
wowed124023772wo_wed
wronged12397672wronged
wyted12529472w_yted
zonated173310532zonated
zoned154020262zon_ed
zonked20429472zonked

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.326548131.9
2DLD Change Limit825511532.14038575.2
3Display Results1531530.0463326.1
 (SQL Overall)1786911532.51271135.0
 
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.