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

104 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
rechanged164685(None) 
rechange1458181rechange_
rechanges1568181rechanges
recharged1656331recharged
rehanged1357831re_hanged
bechanced1945642bechanced
changed144214142__changed
exchanged23113672exchanged
precharged1944552precharged
recaned102817202rec_an_ed
recanted112513512rec_anted
rechannel1444322rechannel
recharge1476612recharge_
recharger1565482recharger
recharges1586952recharges
recharted1557562recharted
rehinged1336852re_hinged
unchanged1636282unchanged
archangel1544313archangel
bechalked2143593bechalked
bechance1747733bechance_
bechances1847613bechances
becharmed1944663becharmed
bethanked1943283bethanked
chanced154113213__chanced
change124116753__change_
changer134215543__changer
changes134517583__changes
chanted134015953__chanted
charged144614023__charged
clanged114212653__clanged
decanted122310493dec_anted
defanged1435433de_fanged
deranged1137693de_ranged
doghanged1642343doghanged
enchanted1546553enchanted
enhanced1436623_enhanced
exchange21124323exchange_
exchanger22123973exchanger
exchanges22124613exchanges
freehanded1843403freehanded
hanged114222393___hanged
mechanized2745883mechanized
merchanted1844483merchanted
precharge1745163precharge_
precharges1845513precharges
ranged84824313r___anged
rearranged1244103rearranged
recalled11310793rec_alled
recane83022873rec_an_e_
recanes93222263rec_an_es
recanter101913153rec_anter
recapped1535943rec_apped
rechallenged1971333rechallenged
rechanging1746043rechanging
rechanneled1752223rechanneled
rechannels1543183rechannels
rechargers1644103rechargers
recharter1466893recharter
rechecked2143973rechecked
rechewed1735633rech_ewed
reckoned1546953reckon_ed
recladded1443673recladded
reclaimed1435543reclaimed
reclasped1444863reclasped
recleaned1236583reclean_ed
reclined113613603reclin_ed
recoaled113111783recoa_led
recoated113416783recoa_ted
recoined113614423recoin_ed
reconned113610653rec_onned
recounted1238713recounted
recrated112918583recra_ted
rectangle1244263rectangle
rectangles1343993rectangles
reflagged1543083reflagged
regauged1135143re_gauged
regranted1137703regranted
rehabbed1663713re_habbed
rehandled1444763re_handled
rehang1039823re_hang__
rehangs1137563re_hang_s
rehashed1536063re_hashed
rehinge1148503re_hinge_
rehinges1248403re_hinges
reimaged1246173reima_ged
relanded102410463re_landed
reloaned939723reloan_ed
remanded123011323re_manded
remanned11319353re_manned
replanned1235163replanned
replanted1248063replanted
replunged1343373replunged
reshaped1437203resha_ped
reshaved1536873resha_ved
reshined123011123reshin_ed
reshingled1542783reshingled
restaged103011853resta_ged
retagged1136063re_tagged
revenged1337553re_venged
richened1435953richen_ed
uncharged1636613uncharged
unhanged13258833_unhanged
whanged15447613__whanged

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411048.42017653.3
3Display Results1041040.0502080.0
 (SQL Overall)1786911048.62620715.4
 
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.