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

123 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
seeresses93905(None) 
peeresses1138451peeresses
depresses1259872depresses
egresses949442_egresses
heiresses1236962heiresses
redresses10410292redresses
regresses10310462regresses
represses11412142represses
seeress7311572seere_s_s
sheernesses1445842sheernesses
stresses81112492s_tresses
actresses1137933actresses
addresses1165633addresses
aggresses1146143aggresses
ancresses1138413ancresses
beerinesses1398903beerinesses
caresses10314063_caresses
cateresses1248353cateresses
cereuses1049243_cereuses
cresses94219813__cresses
cypresses1645853cypresses
dearnesses1139573dearnesses
decreases1237223decreases
deepnesses1366673deepnesses
degreases1146153degreases
depressed1357613depressed
derepresses1444773derepresses
diereses938693diere_ses
digresses1137863digresses
dresses83716173__dresses
duenesses1039323duenesses
duresses939173_duresses
eerinesses10612573_eerinesses
egressed1046873_egressed
eldresses1045673eldresses
empresses1348163empresses
espressos1143963espressos
excesses1736753_excesses
expresses1837863expresses
fewnesses1534953fewnesses
feynesses1535223feynesses
freenesses1339863freenesses
heresies11312693_heresies
impresses1338213impresses
ingresses1038533ingresses
keennesses1445323keennesses
kermesses15284963kermesses
leerinesses11119473leerinesses
meeknesses1644803meeknesses
meetnesses1237443meetnesses
nearnesses1039093nearnesses
newnesses1236123newnesses
ogresses938473_ogresses
onenesses9311823onenesses
oppresses1346873oppresses
peeress939503peere_s_s
phereses1348093phere_ses
poetesses1137233poetesses
precesses13310463precesses
presses93523153__presses
queernesses2044563queernesses
recesses10312323_recesses
recrosses1138373recrosses
rednesses10312303rednesses
redressed1137773redressed
redresser1056793redresser
redressers1145103redressers
reexpresses2043613reexpresses
refreshes1595953refreshes
regressed1138113regressed
repressed12610103repressed
represser1168953represser
repressers1256883repressers
restresses1049313restresses
sadnesses10310303sadnesses
safenesses1349373safenesses
sagenesses11510823sagenesses
samenesses12410853samenesses
sanenesses10412693sanenesses
secrecies1346913secrecies
secretes10410473secre_tes
seedcases1244193seedcases
seedinesses1259203seedinesses
selfnesses1335893selfnesses
serenes73222903s_ere_nes
severeness1346113severeness
severenesses1545583severenesses
sexinesses1739203sexinesses
sherrises12156863sherrises
shynesses1535313shynesses
sidedresses1343513sidedresses
skewnesses1743763skewnesses
sleeknesses1545273sleeknesses
slynesses1235863slynesses
sneeshes1136513sne_eshes
sobernesses1346593sobernesses
solenesses10412703solenesses
sorceresses1343373sorceresses
sorenesses101313483sorenesses
sournesses10310013sournesses
speisses10245693spe_isses
steepnesses1345913steepnesses
stereopses1254693stereopses
sternnesses1146633sternnesses
strasses81311433s_trasses
stressed9128543s_tressed
successes1345643successes
sundresses1146543sundresses
suppresses1446253suppresses
surenesses101212203surenesses
sweetnesses1445723sweetnesses
synereses1245313synere_ses
tendresses1145923tendresses
tigresses1046403tigresses
tresses73719543__tresses
tweenesses1345803tweenesses
undresses1039313undresses
votresses1236503votresses
waenesses1239773waenesses
wetnesses12208213wetnesses
whereases1545673whereases
woenesses1239133woenesses
zebrasses2043513zebrasses

Search took 9 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.1561145455.1
2DLD Change Limit1486411238.42317647.0
3Display Results1231230.0462673.9
 (SQL Overall)1786911238.62520717.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.