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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
richened143595(None) 
lichened1435751lichened
racheted14149502racheted
rechewed1735632rechewed
richen113812512richen__
richens12349732richen_s
richweed17163582richweed
ripened1038202ri_pened
sickened1546782sickened
achene11313813_achene_
achenes12313493_achenes
bickered17108003bickered
brightened1743163brightened
cacheted16148233cacheted
chefed155010563__chefed
chewed154415013__chewed
chickened2144623chickened
chined125620063__chined
ciphered1637053ciphered
cricketed1854683cricketed
crispened1443613crispened
crocheted1745313crocheted
dickered16117533dickered
dithered13189293dithered
dizened18267333di_zened
eschewed1743443eschewed
freshened1645253freshened
frightened1843243frightened
hyphened2044683hyphened
inhered11313163_inhered
kitchenet1844983kitchenet
kittened1334523kittened
lechered1437523lechered
licenced13145773lic_enced
licensed11145723lic_ensed
lichee114017973liche_e_
lichees123512783liche_es
lichen114012743lichen__
lichenin1345053lichenin
lichens123510683lichen_s
lichted13268803lich_ted
lightened1446023lightened
likened12267353li_kened
lippened13255223lippened
listened9168813listened
livened11238933li_vened
machined1637303machined
miched143913393mich__ed
mildened1235773mildened
mittened1136363mittened
niched125514063nich__ed
nickeled15115513nickeled
nickered15117023nickered
ochered132610283_ochered
picketed17167383picketed
pinkened1535753pinkened
quickened2543163quickened
racemed1237013rac_emed
racketed15169123racketed
ratcheted1554783ratcheted
rattened9218623rattened
ravened115012283r_avened
recaned102817203rec_aned
receded112713043rec_eded
rechanged1646853rechanged
rechecked2143973rechecked
reckoned1546953reckoned
recleaned1236583recleaned
reclined113613603reclined
recoined113614423recoined
reconned113610653reconned
reddened1136423reddened
reopened1138503reopened
reshined123011123reshined
ribboned1343973ribboned
riced85825543ric___ed
richening1546223richening
richer114015043rich__er
riches115022083rich__es
richest122813683riche_st
richness1337433richness
richweeds18132813richweeds
ricked136523623ric__ked
ricocheted1852373ricocheted
righted122912143righ_ted
ripener937903ri_pener
riveted11258573ri_veted
rocketed15157793rocketed
roughened1444093roughened
ruched124314633ruch__ed
sacheted14127833sacheted
schemed1577753_schemed
sickener1436603sickener
siphoned1446413siphoned
slickened1644293slickened
thickened1944303thickened
ticketed15146643ticketed
tightened1444963tightened
tochered1437913tochered
unchewed1735803unchewed
widened12328053wi_dened
withered15169433withered
wizened20275423wi_zened

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.1701051123.5
2DLD Change Limit1461621038.17317883.5
3Display Results1031030.0462239.1
 (SQL Overall)1786911038.38921300.6
 
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.