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

101 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
unretired104643(None) 
unretire846961unretire_
unretires945931unretires
retired84620142__retired
unattired1045082unattired
undesired1147522undesired
unrefined1345462unrefined
unrestored1165112unrestored
unrevised1345162unrevised
untired82316382un__tired
antired82316193an__tired
nurtured935253nur_tured
overtired131310253overtired
prefired144310753_prefired
prewired14358473_prewired
refired115116993__refired
rehired115013153__rehired
retied75924983__reti_ed
retiled84420513__retiled
retimed104714653__retimed
retire64927013__retire_
retiree75019083__retiree
retirer74715013__retirer
retires74726213__retires
retried84419163__retried
rewired115413283__rewired
unadmired1343863unadmired
unaired82916013un__aired
unaltered1037723unaltered
unbeared111611653unbe_ared
uncatered1237403uncatered
unchaired1536203unchaired
uncredited1445003uncredited
undecided1445983undecided
undefiled1446113undefiled
undefined1445873undefined
undenied102211563undeni_ed
underbred1338993underbred
underived14310513underived
undeterred1263833undeterred
unedited10249833un_edited
unentered1037573unentered
unexpired1943283unexpired
unfeared121511013unfe_ared
unfettered1443653unfettered
unfired112212453un__fired
unhaired12238763un_haired
unhired112512153un__hired
unitized1839233un_itized
unletted9310313unlet_ted
unlettered1143953unlettered
unlevied1236843unlevi_ed
unmatured1245703unmatured
unmerited1239643unmerited
unmitered1245853unmitered
unmitred1136843unmit_red
unnoticed1243923unnoticed
unpaired11208943un_paired
unpitied1138793unpiti_ed
unprepared1543023unprepared
unraised91811883unr_aised
unrated82621553unrat__ed
unreached1536883unreached
unrealized2047213unrealized
unrebuked1652673unrebuked
unrecorded1443133unrecorded
unreeled91310333unre_eled
unreeved12117673unre_eved
unreformed1643563unreformed
unrelated10310433unrelated
unrelaxed1744463unrelaxed
unrelieved1443513unrelieved
unremarked1743203unremarked
unrenewed1344233unrenewed
unrented92413923unre_nted
unreported1344073unreported
unrequited2043423unrequited
unreserved1443903unreserved
unrested91914513unre_sted
unretiring1145303unretiring
unreviewed1742623unreviewed
unrevoked1743423unrevoked
unrewarded1542993unrewarded
unrimed102211633unr__imed
unseared91113943unse_ared
unsecured1244903unsecured
unseized1838443unse_ized
unsettled1055213unsettled
untenured1044933untenured
untethered1443713untethered
untied73720813un__ti_ed
untimed102713373un__timed
untried82615853un__tried
untutored1043493untutored
unuttered1065733unuttered
unveiled1298163unve_iled
unveined1258003unve_ined
unwatered1345683unwatered
unwearied1336763unwearied
unwetted1238123unwet_ted
upreared1137073upre_ared

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.406440125.6
2DLD Change Limit1486411017.75019179.5
3Display Results1011010.0502020.0
 (SQL Overall)1786911018.20621775.7
 
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.