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

134 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
actresses113793(None) 
accesses1287492ac_cesses
actress948532actre_s_s
actressy1342602actress_y
addresses1165632addresses
aggresses1146142aggresses
ancresses1138412ancresses
aptnesses11168992aptnesses
caresses10314062_caresses
cateresses1248352cateresses
cresses94219812_c_resses
mattresses1245432mattresses
stresses81112492_stresses
tresses73719542__tresses
victresses1544972victresses
votresses1236502votresses
waitresses1345062waitresses
abbesses1235333a_bbesses
abscesses1344103abscesses
acarboses1345083acarboses
acariases1146613acariases
accessed1385403ac_cessed
accretes1238113accre_tes
achinesses1539303achinesses
acidnesses1337253acidnesses
acreages1138373ac_reages
acutenesses13126973acutenesses
addressed1243653addressed
addressee1143963addressee
addressees1252313addressees
addresser1143403addresser
addressers1242673addressers
adultresses1242933adultresses
aggressed1244203aggressed
ancestresses1493273ancestresses
anchoresses1653803anchoresses
antheses11311473anthe_ses
anureses837973anure_ses
appressed1445943appressed
arbitresses1343343arbitresses
archnesses1547173archnesses
artinesses10815213artinesses
assesses737383a_ssesses
atresias839473a_tresias
authoresses1443793authoresses
aviatresses1483003aviatresses
buttresses1245663buttresses
caressed1139163_caressed
caresser1038813_caresser
caressers1137443_caressers
cereuses1049243_cereuses
cesses84221363_c__esses
chesses124112633_c_hesses
creases94020963_c_reases
creeses93914623_c_reeses
cresset93319943_c_resset
cressets10309103_c_ressets
crosses94220793_c_rosses
cypresses1645853cypresses
daftnesses1436383daftnesses
depresses1259883depresses
digresses1137863digresses
distresses1148853distresses
dresses83716173__dresses
duresses939173_duresses
editresses1165073editresses
egresses949443_egresses
eldresses1045673eldresses
electresses1345963electresses
empresses1348163empresses
exactnesses2044343exactnesses
expresses1837863expresses
fastnesses1389083fastnesses
fatnesses121710463fatnesses
fitnesses12219373fitnesses
fortresses1345663fortresses
gastnesses11129143gastnesses
heiresses1236963heiresses
hotnesses1238903hotnesses
hotpresses1544523hotpresses
huntresses1345283huntresses
icinesses11310073icinesses
icteruses1144973icteruses
impresses1338213impresses
ingresses1038533ingresses
lacinesses12312123lacinesses
lacrosses1145303lac_rosses
matrasses1157293matrasses
mattrasses1243833mattrasses
mayoresses1543693mayoresses
mistresses1247993mistresses
ogresses938473_ogresses
oppresses1346873oppresses
oratresses1045493oratresses
outdresses11236823outdresses
outpresses12157253outpresses
packnesses1856633packnesses
pantdresses1443753pantdresses
pastnesses12910513pastnesses
patnesses111611793patnesses
peeresses1138473peeresses
portresses1247313portresses
presses93523153__presses
racinesses12313513racinesses
raptnesses1248523raptnesses
redresses10410293redresses
regresses10310463regresses
represses11412143represses
restresses1049313restresses
saltnesses10310163saltnesses
seeresses939053seeresses
strasses81311443_strasses
stressed9128543_stressed
tacitnesses1336323tacitnesses
tartnesses101110713tartnesses
tautnesses10118283tautnesses
tigresses1046403tigresses
traitresses1144603traitresses
trasses74819323__trasses
tressed83714263__tressed
tressel73010893__tressel
tressels8367653__tressels
trusses73813643__trusses
tutoresses1044373tutoresses
undresses1039313undresses
unstresses1046033unstresses
untrusses945703untrusses
vastnesses13128203vastnesses
vitesses1136333vit_esses
votaresses1343913votaresses
waitressed1442923waitressed
wardresses1445413wardresses
wetnesses12208213wetnesses
witnesses12219923witnesses

Search took 8 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.436409841.7
2DLD Change Limit1486411347.06321045.0
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.56223630.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.