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 “loudened” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
loudened104469(None) 
hoidened1335652hoidened
hoydened1644642hoydened
ladened979052l_adened
leadened1036152leadened
loosened945452loosened
louden73711792louden__
loudens8368052louden_s
louvered1244992louvered
soddened1144642soddened
blondined1343483blondined
bordered1248933bordered
bouldered1344483bouldered
broadened1364333broadened
burdened1236423burdened
clouded11348833cloud__ed
condemned1545103condemned
condensed1387113condensed
condoned122612023condoned
convened143412223convened
cordoned12229613cordoned
cozened19349183co_zened
deadened1137233deadened
doddered1234943doddered
dovened12389063do_vened
dozened18377453do_zened
floundered1542423floundered
foddered1434553foddered
foundered1435403foundered
foureyed1543663foureyed
gardened1137003gardened
gladdened1342583gladdened
goldener1045403goldener
hardened1338613hardened
houseled1237283houseled
laddered1136743laddered
latened8711923l_atened
lauded83812153laud__ed
laundered1185023laundered
laureled934543laureled
leavened1235553leavened
lessened935093lessened
lichened1435753lichened
likened12267353l_ikened
lippened13255223lippened
listened9168813listened
livened11238933l_ivened
loaded84616873load__ed
loaned73816293lo__aned
loden66621143lo_den__
lodens74315063lo_den_s
lodged913815703lo_d_ged
loided83414023loid__ed
loitered938183loitered
loosener845633loosener
loppered13326753loppered
lorded84916733lord__ed
loudening1144743loudening
louder74414603loud__er
loudest839933loude_st
loudlier934943loudlier
loudness937013loudness
lounged9468243lou_nged
louped95316383lou__ped
loupen84510293loupen__
loured74617403lou__red
loused74822913lou__sed
louted74920693lou__ted
louvred11354663lou_vred
lowered112711913lo_wered
maddened1334893maddened
mildened1235773mildened
modeled1139453mo_deled
modemed1336723mo_demed
moldered1237173moldered
mouldered1343753mouldered
mourned1037763mou_rned
omened93711003_o_mened
opened94311863_o_pened
ordered9108533_ordered
pollened1157773pollened
pondered126411293pondered
powdered15256893powdered
queened17105863_queened
reddened1136423reddened
rodeoed937883ro_deoed
roughened1444093roughened
saddened1135343saddened
softened1235663softened
soldered1038153soldered
stoutened1053573stoutened
tautened935423tautened
tokened1236393to_kened
toughened1444223toughened
widened12328053_widened
wondered13239943wondered
woodener1245763woodener
worsened1236053worsened
yodeled1236853yo_deled
youthened1644143youthened

Search took 9 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.1561145455.1
2DLD Change Limit1461621008.50017195.5
3Display Results1001000.0462173.9
 (SQL Overall)1786911008.70220534.5
 
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.