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

106 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
unaverted133656(None) 
unalerted1047961unalerted
averted112211612__averted
inverted122312162in_verted
unabetted1244992unabetted
unaborted1245732unaborted
unavenged1443662unavenged
unversed122310432un_versed
unvested122210222un_vested
adverted1336103_adverted
alerted82512223__alerted
anteverted1443543anteverted
averred11237593__averred
averter102410553__averter
beavered1437503beaver_ed
caveated1439133_caveated
caverned1436163_caverned
cavorted1435693_cavorted
clavered14187633claver_ed
converted15311563converted
diverted13199583_diverted
everted112711853__everted
havered144011453_haver_ed
inserted92413053in_serted
invected14258883in_vected
invented122510663in_vented
inversed12269283in_versed
inverter112411073in_verter
invested12229693in_vested
knaveries1645013knaveries
navette1036983_navette_
navettes1136613_navettes
obverted1435103_obverted
perverted1546093perverted
quavered2144813quaver_ed
reverted122714713_reverted
slavered12188033slaver_ed
subverted1545443subverted
traversed1344563traversed
unabated11310133una_bated
unaccented1544283unaccented
unaccepted1743383unaccepted
unaccrued1442693unaccrued
unacted10312733una__cted
unadapted1344653unadapted
unadopted1344563unadopted
unadorned1144123unadorned
unadvertised1751553unadvertised
unaffected1942943unaffected
unagreed1036823una_greed
unaired82916013una_ir_ed
unalarmed1244633unalarmed
unaltered1037723unalter_ed
unamended1344853unamended
unaneled939793unane_led
unarmed101811923una__rmed
unattested1143373unattested
unaudited1145853unaudited
unaverage1343553unaverage
unavowed1534783unav_owed
unawarded1444923unawarded
unbelted1179333un_belted
uncarted11312053un_carted
uncatered1237403uncater_ed
uncharted1538083uncharted
uncoerced1445313uncoerced
unconverted1744773unconverted
uncovered1546613uncover_ed
uncreated12312303uncreated
undented102313953un_dented
underfed13311713un_derfed
unelected1237823unelected
unfavored1643443unfavor_ed
unfelted1279403un_felted
unharvested1852113unharvested
unheated121514553un_heated
universe1145253universe_
universes1245423universes
unlamented1344353unlamented
unletted9310313un_letted
unmelted1169183un_melted
unmerited1239643un_merited
unnerved1248063un_nerved
unparted11310823un_parted
unpierced1443443unpierced
unraveled1345543unrave_led
unravelled1443863unravelled
unrented92413923un_rented
unrested91914513un_rested
unscented1237513unscented
unseated91317683un_seated
unserved12410233un_served
unshirted13105953unshirted
unsorted9312513un_sorted
untalented1144843untalented
untented92613413un_tented
untested92612413un_tested
untraversed1553083untraversed
untreated10312903untreated
unvaried1239683un_varied
unveiled1298163un_veiled
unveined1258003un_veined
unvexed18147103un_ve_xed
unwatered1345683unwater_ed
unwetted1238123un_wetted
wavered142910433_waver_ed

Search took 8 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.1701051123.5
2DLD Change Limit1486411067.15620771.5
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.37224239.1
 
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.