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

106 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
ironnesses104783(None) 
brownnesses1664372brownnesses
ironness836952ironne_s_s
lornnesses1037822lornnesses
pronenesses1379262pronenesses
wornnesses1337132wornnesses
wrongnesses1544922wrongnesses
airinesses102613613air_inesses
alonenesses1147213alonenesses
archnesses1547173archnesses
aridnesses1139933aridnesses
artinesses10815213artinesses
baronesses1238913baro_nesses
blondnesses1445543blondnesses
boninesses121111453_boninesses
brininesses1338983brininesses
broadnesses1446193broadnesses
brokennesses1843303brokennesses
canonesses1238423canonesses
confesses1438623_confesses
coolnesses1237193coolnesses
corninesses13410593corninesses
coynesses1437573_coynesses
crossnesses1247123crossnesses
direnesses11311483dir_enesses
dirtinesses1239883dirtinesses
donenesses11310563_donenesses
drabnesses1336483drabnesses
drollnesses1244363drollnesses
drynesses1335363dr_ynesses
dunnesses1037703_dunnesses
evennesses1345943evennesses
firmnesses1535613fir_mnesses
firstnesses1445733firstnesses
fondnesses1437703_fondnesses
franknesses1845603franknesses
freenesses1339873freenesses
frozennesses2443223frozennesses
gonenesses11310253_gonenesses
goodnesses1236433goodnesses
gorinesses11311553gorinesses
grandnesses1348113grandnesses
graynesses1436143graynesses
greennesses1247033greennesses
greynesses1446323greynesses
grimnesses13106533grimnesses
grossnesses1146713grossnesses
horninesses1459003horninesses
hotnesses1238903_hotnesses
icinesses11310073i_cinesses
ickinesses1637183ickinesses
idlenesses1138033idlenesses
iffinesses1635583iffinesses
illnesses937283i_llnesses
inanenesses1149523inanenesses
ingrownnesses1751983ingrownnesses
inkinesses1439423inkinesses
iratenesses11411443iratenesses
keennesses1445323keennesses
leannesses10108343leannesses
lionesses939433lio_nesses
lonenesses10311343_lonenesses
longnesses1138503_longnesses
looninesses1197993looninesses
lownesses1236983_lownesses
meannesses12128163meannesses
mirinesses121512313mir_inesses
mooninesses13127943mooninesses
mootnesses1237153mootnesses
morenesses12811393morenesses
nownesses1236893_nownesses
onenesses9311823__onenesses
opennesses1246313opennesses
phoninesses1636453phoninesses
poornesses1236803poornesses
primnesses1497803primnesses
princesses14206263princesses
processes13310233pro_cesses
professes1437873pro_fesses
progresses1347493progresses
prosinesses13310853prosinesses
proudnesses1447503proudnesses
prowesses1437193pro_wesses
ranknesses1438093_ranknesses
rawnesses1288123_rawnesses
rednesses10312313_rednesses
richnesses1537803richnesses
rifenesses1339943rifenesses
riminesses121211413riminesses
ripenesses12310373ripenesses
ropinesses121311023_ropinesses
rosinesses101213143_rosinesses
roundnesses1247043_roundnesses
slownesses1344943slownesses
sorenesses101313493sorenesses
stoninesses1138253stoninesses
thinnesses1346263thinnesses
tirednesses1247743tirednesses
trignesses1188213trignesses
trimnesses1287753trimnesses
truenesses1039313truenesses
vainnesses1337343vainnesses
wannesses1239233_wannesses
wirinesses131811523wir_inesses
woenesses1239133_woenesses
wrynesses1534843wr_ynesses

Search took 7 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.423422437.4
2DLD Change Limit1406031066.36022107.4
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.82926166.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.