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

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

60 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
unexplained215228(None) 
explained1944542__explained
reexplained2152122reexplained
unexploited2152202unexploited
explainer1844243__explainer
unexamined2042573unex_amined
unexpired1943283unexp__ired
unexploded2152163unexpl_oded
unexplored2042633unexpl_ored
unplaited1236883un__plaited
unplanned1244413un__planned
complained17175794_complained
deplaned1238654_de_pla_ned
emplaned1337154__empla_ned
enplaned1137474__enpla_ned
exclaimed2142844__exclaimed
explain1667044__explain__
explainers1943114__explainers
explains1766444__explain_s
explanted1944974__explanted
exploited1944674__exploited
overexplained2683784overexplained
overplaided1845044overplaided
overplanned1744344overplanned
plained103812234____plained
preplanned1543494pre_planned
reexplain1852964reexplain__
reexplains1952764reexplain_s
replanned1235164_re_planned
unapplied1443744unappl_i_ed
uncalcined1543714un_calcined
unchained1537274un__chained
unclaimed1435794un__claimed
uncurtained1452984uncurtained
underlined121610214underl_ined
underplayed1875024underpla_yed
undrained1138524un__drained
unearned9310064une___arned
unemployed1843074unempl_oyed
unenlarged1242124une_nlarged
unexalted1744334unex__alted
unexcited1953984unex__cited
unexercised2152104unexercised
unexpected2243114unexp_ected
unexpended2142704unexp_ended
unexplainable2462524unexplainable
unexposed1943434unexp__osed
unexpressed2173044unexpressed
unimpaired1542054unimp_aired
unlined82515804un___l_ined
unpainted1237184un__p_ainted
unpaired11208944un__p_aired
unplaced1338614un__pla_ced
unplanted1236854un__planted
unplayed1437264un__pla_yed
unreclaimed1652174unreclaimed
unrestrained1353284unrestrained
unstained1038684un__stained
unstrained1146374un_strained
untrained10510994un__trained

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 Filter1786911488190.1561145455.1
2DLD Change Limit148819608.48317543.2
3Display Results60600.0331818.2
 (SQL Overall)178691608.67220605.5
 
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.