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

174 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
tattinesses1112894(None) 
battinesses13169451battinesses
cattinesses13129701cattinesses
fattinesses14118971fattinesses
nattinesses11119321nattinesses
tartinesses111011501tartinesses
tastinesses111110781tastinesses
artinesses10815212_artinesses
bittinesses13148262bittinesses
brattinesses1466262brattinesses
chattinesses1755152chattinesses
dottinesses1238132dottinesses
hastinesses141210692hastinesses
jettinesses1836382jettinesses
maltinesses13310232maltinesses
matinesses12314542ma_tinesses
nastinesses111110742nastinesses
nuttinesses11117752nuttinesses
pastinesses13911712pastinesses
pettinesses1338632pettinesses
pottinesses1339102pottinesses
ruttinesses11128992ruttinesses
saltinesses11311452saltinesses
tacitnesses1336322tacitnesses
tackinesses1737252tackinesses
talkinesses1537352talkinesses
tanginesses1278882tanginesses
tardinesses121110252tardinesses
tarrinesses11129082tarrinesses
tartnesses101110712tart_nesses
tattiness9239412tattine_s_s
tautnesses10118282taut_nesses
tawninesses1436152tawninesses
testinesses111210322testinesses
wittinesses14127482wittinesses
achinesses1539303_achinesses
airinesses102613613_airinesses
antsinesses1148753antsinesses
aptnesses11168993_apt_nesses
artsinesses1138713artsinesses
ashinesses1339163_ashinesses
bagginesses1545953bagginesses
balkinesses1767503balkinesses
balminesses1537253balminesses
bandinesses14109733bandinesses
battiness11239843battine_s_s
bawdinesses17126323bawdinesses
bustinesses131310093bustinesses
caginesses13310943ca_ginesses
cakinesses16310613ca_kinesses
campinesses1737113campinesses
canninesses1368853canninesses
cattiness112310633cattine_s_s
craftinesses1746383craftinesses
daffinesses1834843daffinesses
daftnesses1436383daft_nesses
dailinesses1249493dailinesses
daintinesses1346243daintinesses
datednesses1357903datednesses
dirtinesses1239883dirtinesses
ditsinesses12108763ditsinesses
ditzinesses21126213ditzinesses
draftinesses1645753draftinesses
dustinesses121110353dustinesses
earlinesses11311043earlinesses
earthinesses1545823earthinesses
easinesses10314443ea_sinesses
emptinesses1545993emptinesses
fancinesses1638143fancinesses
fastnesses1389083fast_nesses
fatalnesses1456283fatalnesses
fatnesses121710463fa_t_nesses
fattiness12239373fattine_s_s
faultinesses1545183faultinesses
fustinesses14129783fustinesses
gabbinesses1634903gabbinesses
gaminesses13410463ga_minesses
gassinesses1197973gassinesses
gastnesses11129143gast_nesses
gaudinesses1337853gaudinesses
gauzinesses2136043gauzinesses
gawkinesses1935633gawkinesses
goutinesses1239973goutinesses
grittinesses1345843grittinesses
gustinesses12139523gustinesses
gutsinesses12128153gutsinesses
hairinesses14198943hairinesses
hamminesses1835773hamminesses
handinesses151410273handinesses
happinesses1876163happinesses
hardinesses151110223hardinesses
hazinesses2239223ha_zinesses
heartinesses1548003heartinesses
heftinesses1737133heftinesses
jauntinesses1944683jauntinesses
jazzinesses2633373jazzinesses
knottinesses1643913knottinesses
lacinesses12312123la_cinesses
lankinesses1539013lankinesses
larkinesses1538993larkinesses
latenesses10413363la_tenesses
lazinesses19310153la_zinesses
loftinesses1437923loftinesses
lustinesses11910423lustinesses
manginesses1499593manginesses
manlinesses13910193manlinesses
massinesses12128693massinesses
mateynesses1645173mateynesses
mattresses1245433matt_resses
mazinesses2139923ma_zinesses
meatinesses13311983meatinesses
mistinesses131310623mistinesses
mustinesses131010413mustinesses
nappinesses1555923nappinesses
nattiness9239333nattine_s_s
niftinesses1437243niftinesses
paltrinesses1445513paltrinesses
pastnesses12910513past_nesses
patchinesses1944363patchinesses
patnesses111611793pa_t_nesses
patronesses1346473patronesses
pawkinesses2036153pawkinesses
pithinesses1637503pithinesses
prettinesses1447543prettinesses
racinesses12313513ra_cinesses
raininesses11310483raininesses
randinesses121311203randinesses
ranginesses121210113ranginesses
raptnesses1248523rapt_nesses
raspinesses1338013raspinesses
ritzinesses2096743ritzinesses
rootinesses1139523rootinesses
runtinesses111210963runtinesses
rustinesses11911553rustinesses
saltnesses10310163salt_nesses
sandinesses12911393sandinesses
sappinesses1567563sappinesses
sassinesses999323sassinesses
saucinesses1338983saucinesses
savvinesses1735663savvinesses
scantinesses1437313scantinesses
slatinesses11311633slatinesses
smuttinesses14135083smuttinesses
snottinesses1255843snottinesses
sootinesses11410053sootinesses
spottinesses1445683spottinesses
staginesses1238463sta_ginesses
statelinesses1344233statelinesses
tallnesses1037473ta_llnesses
tamenesses1259973ta_menesses
tartiness92112053tartine_s_s
tastiness92311143tastine_s_s
tawdrinesses1643433tawdrinesses
tearinesses11311693tearinesses
tetchinesses1753553tetchinesses
tidinesses1139223t_idinesses
tininesses10311163t_ininesses
tinninesses1136863tinninesses
tipsinesses1336363tipsinesses
titanesses1037253t_itanesses
trashinesses1546113trashinesses
tritenesses11710393tritenesses
trustinesses12116983trustinesses
tubbinesses1544383tubbinesses
vastnesses13128203vast_nesses
wackinesses2036653wackinesses
warinesses131514523wa_rinesses
washinesses1737263washinesses
waspinesses1636703waspinesses
waterinesses1567193waterinesses
wavinesses16199283wa_vinesses
waxinesses20138763wa_xinesses
yeastinesses1545563yeastinesses
zaninesses19310383za_ninesses

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 Filter1786911216330.410435831.7
2DLD Change Limit1216331744.45027333.3
3Display Results1741740.0931871.0
 (SQL Overall)1786911744.95336077.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.