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

70 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
unmarried124458(None) 
unharried1344761unharried
unmarred11258401unmarr_ed
unmarrieds1341531unmarrieds
married104715302__married
remarried1244932remarried
unbarred11238702unbarr_ed
unhurried1343292unhurried
unmarked15248812unma_rked
unvaried1239682unva_ried
unworried1344012unworried
carried103717153__carried
gnarred9327003gn_arr_ed
harried113815533__harried
knarred12266003kn_arr_ed
marred95421043__marr_ed
marrieds11288073__marrieds
marrier93817523__marrier
marries93825283__marries
parried103615723__parried
quarried1836093_quarried
recarried1244983recarried
remarries1147673remarries
tarried83914133__tarried
unagreed1036823un_agreed
unaired82916013un_air_ed
unallied938393un_allied
unarched14128553un_arched
unargued1035583un_argued
unarmed101811923un_a_rmed
unarrayed1344183un_arrayed
unbarbed13217753unba_rbed
unbarring1236063unbarring
unburied11208513un_buried
uncarded12310133unca_rded
uncarted11312053unca_rted
uncarved1438163unca_rved
uncharred1536103uncharr_ed
undried92314613un__dried
unearned9310063unea_rned
unearthed1345573unearthed
ungarbed12197063unga_rbed
unhaired12238763unhair_ed
unharmed1438093unha_rmed
unmailed11229763unma_iled
unmanaged1344493unmanaged
unmanlier1144243unmanlier
unmanned11268603unma_nned
unmapped1535173unma_pped
unmasked15267143unma_sked
unmatched1744203unmatched
unmated103317023unma__ted
unmatted1138293unma_tted
unmatured1245693unmatured
unmerited1239643unmerited
unmitred1136843unmitr_ed
unmoored1137333unmoor_ed
unmortised1343993unmortised
unmourned1254153unmourned
unpaired11208943unpair_ed
unparted11310823unpa_rted
unsalaried1144033unsalaried
unscarred1235673unscarr_ed
unstarred1036363unstarr_ed
untried82615853un__tried
unwarier1136883unwa_rier
unwarmed1437303unwa_rmed
unwarned1238453unwa_rned
unwarped1436873unwa_rped
unwearied1336763unwearied

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.423422437.4
2DLD Change Limit148641706.61022487.3
3Display Results70700.0302333.3
 (SQL Overall)178691707.06325299.6
 
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.