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

112 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
primnesses149780(None) 
grimnesses13106541grimnesses
primenesses1548991primenesses
trimnesses1287751trimnesses
aridnesses1139942aridnesses
dimnesses1238212_dimnesses
firmnesses1535622firmnesses
griminesses14167572griminesses
primness1276762primne_s_s
princesses14206272princesses
prioresses1245702prioresses
riminesses121211422_riminesses
slimnesses1236422slimnesses
trignesses1188212trignesses
acidnesses1337253acidnesses
acridnesses1445793acridnesses
airinesses102613633airinesses
archnesses1547173archnesses
artinesses10815233artinesses
avidnesses1436463avidnesses
bignesses1267963_bignesses
briefnesses1644943briefnesses
brininesses1339003brininesses
brisknesses1745593brisknesses
calmnesses1436843calmnesses
chicnesses1745213chicnesses
crispnesses1545953crispnesses
direnesses11311483direnesses
drabnesses1336483drabnesses
drynesses1335363dr_ynesses
eerinesses10612603eeri_nesses
evilnesses1346003evilnesses
fairnesses1357383fairnesses
finesses111912343_fi_nesses
fitnesses12219373_fitnesses
frailnesses1447603frailnesses
freenesses1339873freenesses
gaminesses13410463gaminesses
germinesses1437883germinesses
glibnesses1344763glibnesses
glumnesses1344733glumnesses
gorinesses11311553gori_nesses
graynesses1436143graynesses
greynesses1446323greynesses
grimness1176003grimne_s_s
hipnesses1436753_hipnesses
hominesses15510873hominesses
icinesses11310073ici_nesses
ironnesses1047833ironnesses
kirmesses15253903kirm_esses
liminesses121310853_liminesses
limpnesses14116653_limpnesses
lionesses939433_lionesses
luridnesses1246723luridnesses
mirinesses121512323mirinesses
packnesses1856633packnesses
palenesses12312663palenesses
pastnesses12910513pastnesses
patnesses111611793p_atnesses
perkinesses1748933perkinesses
pertnesses12310313pertnesses
pinknesses1636583pinknesses
pipinesses1448603pipinesses
pixinesses1937373pixinesses
plainnesses1356213plainnesses
plumbnesses1753073plumbnesses
plumpnesses1753263plumpnesses
pokinesses1669613pokinesses
poornesses1236803poornesses
porkinesses1748783porkinesses
poshnesses1537463poshnesses
preblesses1445103preblesses
precesses13310463pr_ecesses
premisses13288763prem_isses
presses93523153pr___esses
priestesses13104273priestesses
primeness1338663primenes_s
primroses1344843prim_roses
primuses1237083prim__uses
princesse13264403princesse_
prisses94816713pri___sses
prissinesses1355973prissinesses
processes13310233pr_ocesses
professes1437873pr_ofesses
progresses1347493progresses
promptnesses1843633promptnesses
pronenesses1379263pronenesses
prosinesses13310863prosinesses
proudnesses1447503proudnesses
prowesses1437193pr_owesses
puninesses121110753puninesses
purenesses12810743purenesses
pursinesses1338763pursinesses
rawnesses1288123_rawnesses
rednesses10312313_rednesses
richnesses1537803_richnesses
rifenesses1339953_rifenesses
ripenesses12310383_ripenesses
sliminesses1338093sliminesses
sprynesses1544973spr_ynesses
thinnesses1346273thinnesses
trimness1067563trimne_s_s
tritenesses11710393tritenesses
truenesses1039313truenesses
vainnesses1337343vainnesses
voidnesses1436843voidnesses
warinesses131514533wari_nesses
warmnesses15167353warmnesses
wirinesses131811533wirinesses
witnesses12219923_witnesses
worminesses16127993worminesses
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.436409841.7
2DLD Change Limit1406031125.84324063.5
3Display Results1121120.0631777.8
 (SQL Overall)1786911126.34228175.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.