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 “poornesses” 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
poornesses123680(None) 
coolnesses1237192coolnesses
dournesses1138242dournesses
goodnesses1236432goodnesses
mootnesses1237152mootnesses
pokinesses1669612pokinesses
poorness1036362poorne_s_s
poshnesses1537462poshnesses
sournesses10310012sournesses
aloofnesses1443413aloofnesses
baronesses1238913baronesses
boldnesses1337233boldnesses
boninesses121111453boninesses
boozinesses22175803boozinesses
boxinesses19127903boxinesses
coldnesses1338423coldnesses
cosinesses121012823cosinesses
coynesses1437573_coynesses
cozinesses21179503cozinesses
dearnesses1139583dearnesses
donenesses11310563donenesses
dopinesses13159723dopinesses
dozinesses20168633dozinesses
fairnesses1357383fairnesses
farnesses122310813_farnesses
fondnesses1437703fondnesses
foulnesses1337933foulnesses
foxinesses20127733foxinesses
fozinesses22158193fozinesses
gonenesses11310253gonenesses
gooeynesses1544193gooeynesses
goofinesses1535963goofinesses
gorinesses11311553gorinesses
governesses1546723governesses
harnesses121812073_harnesses
hoarinesses14310223hoarinesses
hokinesses1758943hokinesses
holinesses13511493holinesses
hominesses15510863hominesses
hotnesses1238903_hotnesses
ironnesses1047833ironnesses
jokinesses2147533jokinesses
kookinesses1435373kookinesses
lionesses939433lio_nesses
loginesses11410323loginesses
lonenesses10311343lonenesses
longnesses1138503longnesses
looninesses1197993looninesses
loopinesses13116733loopinesses
loosenesses1147243loosenesses
lornnesses1037823lornnesses
lostnesses1049303lostnesses
loudnesses1138433loudnesses
lownesses1236983_lownesses
moodinesses14147643moodinesses
mooninesses13127943mooninesses
mopinesses14139123mopinesses
morenesses12811393morenesses
nearnesses1039103nearnesses
nosinesses101411323nosinesses
nownesses1236893_nownesses
oddnesses1136353_oddnesses
ogresses938473_ogr_esses
oldnesses1037703_oldnesses
onenesses9311823_onenesses
oozinesses19178023oozinesses
opennesses1246313opennesses
oppresses1346873oppr_esses
packnesses1856633packnesses
palenesses12312663palenesses
pastnesses12910513pastnesses
patnesses111611793p_atnesses
patronesses1346473patronesses
peartnesses1338743peartnesses
peeresses1138473peer_esses
pertnesses12310313pertnesses
phoninesses1636453phoninesses
phoresies1447993phor_esies
pinknesses1636583pinknesses
piousnesses1348983piousnesses
pipinesses1448603pipinesses
pixinesses1937373pixinesses
poetesses1137233p_oetesses
politesses1245363politesses
poorhouses1545293poorhouses
porkinesses1748773porkinesses
porousnesses1469283porousnesses
portresses1247313portresses
possesses1046323p_ossesses
pottinesses1339103pottinesses
presses93523153p__r_esses
primnesses1497803primnesses
prioresses1245703prior_esses
processes13310233pro_cesses
professes1437873pro_fesses
progresses1347493progresses
pronenesses1379263pronenesses
propernesses1645013propernesses
prosinesses13310853prosinesses
proudnesses1447503proudnesses
prowesses1437193pro_wesses
puninesses121110753puninesses
purenesses12810743purenesses
roominesses1337433roominesses
rootinesses1139523rootinesses
ropinesses121311023ropinesses
rosinesses101213143rosinesses
shortnesses1446793shortnesses
slownesses1344943slownesses
sobernesses1346593sobernesses
softnesses1337603softnesses
solenesses10412703solenesses
sootinesses11410053sootinesses
sorenesses101313493sorenesses
sorrinesses11310093sorrinesses
spookinesses1844093spookinesses
voidnesses1436843voidnesses
votresses1236503votr_esses
woenesses1239133_woenesses
woodinesses15127463woodinesses
woolinesses14157503woolinesses
woozinesses23175633woozinesses
wornnesses1337133wornnesses

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 Filter1786911406030.406440125.6
2DLD Change Limit1406031237.25019393.5
3Display Results1231230.0602050.0
 (SQL Overall)1786911237.71623158.5
 
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.