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 “unanticipated” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
unanticipated186224(None) 
anticipated1665632__anticipated
unanticipatedly237822unanticipatedly
anticipate1467733__anticipate_
anticipates1586983__anticipates
participated1953703_participated
unarticulated1653843unarticulated
unintimidated1762003unintimidated
anticipator1555094__anticipator
emancipated1852874eman__cipated
participate1754734_participate_
participates1854304_participates
unaffiliated1952424unaffili_ated
unassimilated1662214unassimilated
unassociated1552764unassoci_ated
uninitiated1264864unin_iti_ated
vaticinated1753434_va_ticinated
annihilated1552875__annihilated
annunciated14122605an_nunci_ated
anticipant1456825__anticipa_nt
anticipants1555065__anticipants
anticipating1756265__anticipating
anticipation1668285__anticipation
anticipators1654675__anticipators
anticipatory1953715__anticipatory
antiquated2055485__anti_quated
articulated1447625__articulated
cantillated1445125_canti_llated
denticulated1654395_denticulated
emancipate1653545eman__cipate_
emancipates1753235eman__cipates
enunciated1344975enun__ci_ated
inactivated1744555inact__ivated
inarticulate1454565inarticulate_
inarticulates1554195inarticulates
intimidated15124925__intimidated
lancinated1345575_lan__cinated
masticated1548235_mastic__ated
participator1853545_participator
pontificated2063095_pontificated
quantitated2152925quant__itated
ratiocinated1552235_ra_tiocinated
rearticulated1654155rearticulated
unaccepted1743385una__ccep_ted
unacclimated1952815una_cclimated
unadjudicated2561405unadjudicated
unalienated1244015una_li_enated
unalleviated1651885unallevi_ated
unallocated14113325unalloc__ated
unannotated1252275unan__notated
unappreciated2062455unappreci_ated
unaspirated1444245una__spirated
unattenuated1351775una_ttenuated
unattributed1561545una_ttributed
unautomated1453305unaut__omated
unciliated1348055u__ncili_ated
uncontaminated1972835uncontaminated
undedicated1654815undedic__ated
unindicted1443685unindic___ted
uninhibited1752395uninhibi__ted
uninitiate1074695unin_iti_ate_
uninitiates1164005unin_iti_ates
uninoculated1552965unin_oculated
unintegrated1453305unint_egrated
unmanipulated1871715unman_ipulated
unmedicated1744105unmedic__ated
unmitigated1553725u__nmitigated
unmotivated1753515unmot__ivated
unsolicited1453355unsolici__ted
unvaccinated2062395un_vaccinated
unventilated1653515unvent__ilated
urticated1247695u__rtic__ated
vaticinate1544575_va_ticinate_
vaticinates1643925_va_ticinates

Search took 10 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 Filter1786911247900.406440125.6
2DLD Change Limit124790748.95313938.3
3Display Results74740.0461608.7
 (SQL Overall)178691749.40518999.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.