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

98 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
terseness94840(None) 
tenseness947111tenseness
averseness1345022averseness
denseness1046862denseness
terpenes102111562terpene_s
terrenes82212602terrene_s
tersenesses1149042tersenesses
trueness838692t_rueness
adverseness1553603adverseness
bareness10912813bar_eness
baseness10910943_baseness
berseems1263933berse_ems
ceaseless1135733ceaseless
closeness1137613closeness
coarseness1246173coarseness
cursedness1344463cursedness
direness9311303dir_eness
diverseness1554773diverseness
easiness8313043_easiness
eeriness8311873eer_iness
falseness1236093falseness
fierceness1543793fierceness
firstness1245013firstness
freeness11710443_freeness
freshness1545943freshness
germiness1257693germiness
harshness1545963harshness
hoarseness1345303hoarseness
horseless1237213horseless
horsiness12259473horsiness
intenseness1156573intenseness
jerkiness20175643jerkiness
kerosenes1345453kerosene_s
largeness1038273largeness
looseness937473looseness
menseless1145203menseless
merriness1138293merriness
messiness11248223messiness
moreness10911573mor_eness
moroseness1246213moroseness
nerdiness10208333nerdiness
nerveless1243933nerveless
nerviness12226873nerviness
newsiness1236033newsiness
obeseness1145893obeseness
operoseness1354833operoseness
otioseness1045043otioseness
perkiness15209163perkiness
pertness10310093per_tness
pureness101110183pur_eness
pursiness1138453pursiness
rareness81112853rar_eness
sarsenets946513sarsenets
senseless945973senseless
sereneness1047133sereneness
serenes73222903ser_ene_s
serenest82717623ser_enest
soreness8914793sor_eness
sparseness1245493sparseness
sternness946093ster_nness
sureness8912903sur_eness
tameness102411253t_ameness
tardiness10229913tardiness
tarriness9229243tarriness
tartiness92112053tartiness
tartness82210133tar_tness
teariness9310633teariness
teaselers9165843teaselers
teeners74415453te__eners
tenderness1145283tenderness
tensenesses1147613tensenesses
tepidness1244343tepidness
tercelets1144813tercelets
terebenes1146063terebene_s
termless1036233ter_mless
ternes65422903ter__ne_s
terpene92310853terpene__
terpeneless1361773terpeneless
terranes82514433terrane_s
terreens8246533terre_ens
terrene72411033terrene__
terrenely1243843terrenely
terrines82117553terrine_s
tersest71713993ters__est
terylenes1244923terylene_s
testiness9209753testiness
tipsiness1135703tipsiness
tiredness1036933tiredness
tireless82510263tir_eless
treeless839283t_reeless
trienes74118413t_riene_s
trigness968403t_rigness
trimness1067563t_rimness
triteness9310363triteness
tweeness11246403t_weeness
verboseness1652863verboseness
versines112213823versine_s
wiseness112010753_wiseness

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 Filter1786911486410.1701051123.5
2DLD Change Limit148641989.45615719.2
3Display Results98980.0462130.4
 (SQL Overall)178691989.67218475.1
 
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.