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

98 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
unalerted104796(None) 
unaverted1336561unaverted
alerted82512222__alerted
unabetted1244992unabetted
unaborted1245732unaborted
unalarmed1244632unalarmed
unaltered1037722unalter_ed
unelected1237822unelected
unletted9310312un_letted
untalented1144842untalented
alerter72111513__alerter
antlered938263antler_ed
averted112211613__averted
galeated104111583_galeated
inflected1546053inflected
inserted92413053in_serted
inverted122312163in_verted
nucleated1247873nucleated
talented938423_talented
unabated11310133una_bated
unaccented1544283unaccented
unaccepted1743383unaccepted
unaccrued1442693unaccrued
unacted10312733una__cted
unadapted1344653unadapted
unadopted1344563unadopted
unadorned1144123unadorned
unaffected1942943unaffected
unagreed1036823una_greed
unaired82916013una_ir_ed
unalienated1244013unalienated
unaligned1144873unaligned
unallayed1344073unallayed
unalleged1144453unalleged
unallied938393unal_lied
unallowed1344413unallowed
unalloyed1343723unalloyed
unamended1344853unamended
unaneled939793unane_led
unarmed101811923una__rmed
unattested1143373unattested
unaudited1145853unaudited
unavenged1443663unavenged
unawarded1444923unawarded
unbelted1179333un_belted
unblended13265853unblended
unblessed1245323unblessed
unblurred1243003unblurred
uncarted11312053un_carted
uncatered1237403uncater_ed
uncharted1538083uncharted
uncleaned1237173uncleaned
uncleared1237543uncleared
uncoerced1445313uncoerced
uncreated12312303uncreated
undeleted1148063undeleted
undented102313953un_dented
underfed13311713un_derfed
unfelted1279403un_felted
unfledged1543563unfledged
unflexed1935263unfle_xed
unfluted1237173unfl_uted
unheated121514553un_heated
unlamented1344353unlamented
unleaded10411333un_leaded
unlearned1035653un_learned
unleased9310713un_leased
unlevied1236843un_levied
unlisted9311153un_listed
unmelted1169183un_melted
unmerited1239643un_merited
unmolested1343783unmolested
unnerved1248063un_nerved
unparted11310823un_parted
unpierced1443443unpierced
unplaited1236883unplaited
unplanted1236853unplanted
unpleased1236083unpleased
unpledged1443843unpledged
unrelated10310433unrelated
unrented92413923un_rented
unrested91914513un_rested
unsalaried1144033unsalaried
unsalted9510923unsal__ted
unscented1237513unscented
unseated91317683un_seated
unselected1344973unselected
unserved12410233un_served
unshirted13105953unshirted
unsorted9312513un_sorted
untented92613413un_tented
untested92612413un_tested
untreated10312903untreated
unversed122310433un_versed
unvested122210223un_vested
unwatered1345683unwater_ed
unwetted1238123un_wetted
valeted1139013_vale_ted

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.420425454.8
2DLD Change Limit148641986.78321913.8
3Display Results98980.0462130.4
 (SQL Overall)178691987.24924650.4
 
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.