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

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

56 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
temperatenesses19113151temperatenesses_
desperatenesses1863743desperatenesses_
temperateness1764423temperatene_s_s_
separatenesses1654264se_paratenesses_
temporarinesses1961984temporarinesses_
desperateness1665195desperatene_s_s_
disparatenesses18122885disparatenesses_
expertnesses2144845_exper_t_nesses_
intemperateness1972735intemperatene_s_s_
literatenesses1464785_literatenesses_
moderatenesses1764405_moderatenesses_
accuratenesses1853086_accuratenesses_
aggregatenesses1871576aggregatenesses_
averagenesses1755016__averagenesses_
completenesses2053996comp_letenesses_
dementednesses1853816dem_e_ntednesses_
demurenesses1544756dem_ur__enesses_
depravednesses2152376de_p_ravednesses_
desolatenesses1553976de_solatenesses_
effetenesses1854526_effe__tenesses_
elaboratenesses1762046elaboratenesses_
emptinesses1545996_emp___tinesses_
expectednesses2662956_expe_ctednesses_
femalenesses1746866fem___alenesses_
immediatenesses2062186immediatenesses_
impolitenesses1853956_impolitenesses_
impurenesses16164436_impur__enesses_
inexpertnesses2362416inexper_t_nesses_
iratenesses11411446____iratenesses_
meatinesses13311986__m_e_atinesses_
memorablenesses2154836mem_orablenesses_
obduratenesses1752906_obduratenesses_
operativenesses2055776__operativenesses_
operosenesses1575326__operosenesses_
peartnesses1338746___peart_nesses_
pepperinesses1653276pepper__inesses_
pertnesses12310316___per_t_nesses_
perversenesses1952666perver_senesses_
pervertednesses2162766perver_tednesses_
petitenesses14169366___petitenesses_
remotenesses1446816rem___otenesses_
repletenesses1554496re_p_letenesses_
sedatenesses1346966___sedatenesses_
separablenesses1954786se_parablenesses_
separateness1455506se_paratene_s_s_
severenesses1545616se_ver__enesses_
superablenesses1964906_superablenesses_
temperaments1853666temperamen___ts_
temperances1754736tempera__n__ces_
temperatures1652286temperat___ures_
temporariness1762486temporarine_s_s_
temptresses1543596temp___t_resses_
tendernesses1345076tender___nesses_
tersenesses1149046t___er_senesses_
tritenesses11710396t____ritenesses_
venerablenesses2074806ve_nerablenesses_

Search took 5 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 Filter178691658740.313570897.8
2DLD Change Limit65874564.45314793.2
3Display Results56560.0301866.7
 (SQL Overall)178691564.79637258.3
 
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.