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

168 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
testinesses11121032(None) 
tastinesses111110781tastinesses
bustinesses131310102bustinesses
dustinesses121110352dustinesses
feistinesses1555892feistinesses
fustinesses14129782fustinesses
gustinesses12139532gustinesses
hastinesses141210692hastinesses
heftinesses1737132heftinesses
jettinesses1836382jettinesses
lustinesses11910422lustinesses
meatinesses13311982meatinesses
messinesses1297512messinesses
mistinesses131310622mistinesses
mustinesses131010412mustinesses
nastinesses111110742nastinesses
pastinesses13911722pastinesses
peskinesses1746572peskinesses
pettinesses1338632pettinesses
rustinesses11911562rustinesses
tartinesses111011512tartinesses
tattinesses11128942tattinesses
tearinesses11311692tearinesses
testiness9209752testine_s_s
trustinesses12116992trustinesses
yeastinesses1545562yeastinesses
antsinesses1148763antsinesses
artinesses10815233_artinesses
artsinesses1138733artsinesses
ashinesses1339163_ashinesses
battinesses13169453battinesses
beadinesses1449563beadinesses
beastlinesses1563423beastlinesses
beefinesses1675953beefinesses
beerinesses1398923beerinesses
bittinesses13148263bittinesses
boskinesses17136813boskinesses
bossinesses12117353bossinesses
bushinesses16107473bushinesses
businesses121411393bus_inesses
cattinesses13129703cattinesses
cosinesses121012823cos_inesses
costlinesses1446253costlinesses
crustinesses14137643crustinesses
cushinesses16127413cushinesses
deftnesses1436813deft_nesses
dewinesses1438353de_winesses
dirtinesses1239883dirtinesses
ditsinesses12108773ditsinesses
dottinesses1238133dottinesses
dressinesses1245533dressinesses
duskinesses16136843duskinesses
easinesses10314443_easinesses
edginesses1236703_edginesses
eerinesses10612603_eerinesses
emptinesses1545993emptinesses
fastnesses1389083fast_nesses
fattinesses14118973fattinesses
festivenesses1998433festivenesses
fetidnesses1546653fe_tidnesses
fishinesses17107253fishinesses
fleshinesses18114363fleshinesses
frostinesses1546533frostinesses
fussinesses13126943fussinesses
gassinesses1197983gassinesses
gastnesses11129153gast_nesses
geekinesses1635813geekinesses
gemminesses1634983gemminesses
gentilesses1243493gentilesses
germinesses1437883germinesses
goutinesses1239983goutinesses
gushinesses15127033gushinesses
gutsinesses12128163gutsinesses
headinesses1539843headinesses
heartinesses1548003heartinesses
heavinesses1747453heavinesses
huskinesses18136533huskinesses
jerkinesses2246053jerkinesses
justnesses1736493just_nesses
leafinesses1437873leafinesses
leakinesses1538473leakinesses
leerinesses11119483leerinesses
legginesses1345293legginesses
loftinesses1437923loftinesses
lostnesses1049303lost_nesses
maltinesses13310233maltinesses
massinesses12128693massinesses
matinesses12314543_matinesses
mealinesses13310973mealinesses
meetnesses1237453meet_nesses
merrinesses1358263merrinesses
mossinesses12117463mossinesses
mushinesses16127323mushinesses
muskinesses17127043muskinesses
mussinesses12147443mussinesses
nattinesses11119323nattinesses
neatnesses10310013neat_nesses
needinesses1258103needinesses
nerdinesses1249053nerdinesses
nervinesses1437323nervinesses
newsinesses1436323newsinesses
niftinesses1437243niftinesses
nosinesses101411323nos_inesses
nuttinesses11117753nuttinesses
pastnesses12910513past_nesses
peppinesses1435313peppinesses
perkinesses1748933perkinesses
pertnesses12310313pert_nesses
pottinesses1339103pottinesses
prettinesses1447543prettinesses
pushinesses1697333pushinesses
raspinesses1338013raspinesses
readinesses12611273readinesses
reedinesses1259563reedinesses
restivenesses1679443restivenesses
restresses1049313rest_resses
riskinesses1537843riskinesses
rootinesses1139523rootinesses
rosinesses101213153ros_inesses
runtinesses111210963runtinesses
ruttinesses11128993ruttinesses
saltinesses11311453saltinesses
sassinesses999323sassinesses
seaminesses13310753seaminesses
seedinesses1259203seedinesses
sexinesses1739213se_xinesses
sissinesses9118323sissinesses
slatinesses11311633slatinesses
sootinesses11410053sootinesses
steadinesses1346903steadinesses
steaminesses1446223steaminesses
steelinesses1246723steelinesses
sweatinesses1546913sweatinesses
tacitnesses1336323tacitnesses
tackinesses1737253tackinesses
talkinesses1537353talkinesses
tanginesses1278883tanginesses
tardinesses121110263tardinesses
tarrinesses11129093tarrinesses
tartnesses101110713tart_nesses
tastiness92311143tastine_s_s
tautnesses10118283taut_nesses
tawninesses1436153tawninesses
tensenesses1147613tensenesses
tepidnesses1445383tepidnesses
tersenesses1149043tersenesses
testcrosses1351873testcrosses
tetchinesses1753553tetchinesses
thirstinesses1642583thirstinesses
tidinesses1139223t_idinesses
tininesses10311163t_ininesses
tinninesses1136863tinninesses
tipsinesses1336373tipsinesses
titanesses1037253t_itanesses
trashinesses1546113trashinesses
trendinesses1346323trendinesses
tritenesses11710393tritenesses
tubbinesses1544383tubbinesses
tweedinesses1643613tweedinesses
vastnesses13128203vast_nesses
washinesses1737263washinesses
waspinesses1636703waspinesses
wearinesses14310213wearinesses
weedinesses1557073weedinesses
weepinesses1646133weepinesses
wetnesses12208213we_t_nesses
wispinesses1636273wispinesses
wittinesses14127483wittinesses

Search took 6 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 Filter1786911216330.393454684.5
2DLD Change Limit1216331685.15323604.3
3Display Results1681680.0961750.0
 (SQL Overall)1786911685.64231671.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.