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

117 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
firmnesses153562(None) 
airinesses102613632airinesses
dimnesses1238212di_mnesses
direnesses11311482direnesses
fairnesses1357382fair_nesses
farnesses122310812far_nesses
fierinesses1439242fierinesses
filminesses1636242filminesses
finenesses13310722finenesses
finesses111912342fi__nesses
firmness1334742firmne_s_s
firstnesses1445732firstnesses
fitnesses12219372fi_tnesses
grimnesses13106542grimnesses
kirmesses15253902kirm_esses
mirinesses121512322mirinesses
primnesses1497802primnesses
trimnesses1287752trimnesses
warmnesses15167352warmnesses
wirinesses131811532wirinesses
aridnesses1139943aridnesses
barenesses12311703barenesses
baronesses1238913baronesses
biasnesses1236963biasnesses
bignesses1267963bi_gnesses
calmnesses1436843calmnesses
curtnesses1238373curtnesses
darknesses1537013darknesses
dirtinesses1239883dirtinesses
drynesses1335363_drynesses
eerinesses10612603eerinesses
faintnesses1447143faintnesses
fastnesses1389083fastnesses
fatnesses121710463f_atnesses
fellnesses1346083fellnesses
fewnesses1534953f_ewnesses
feynesses1535223f_eynesses
fiercenesses1744313fiercenesses
finesse10187643fi__nesse_
finessed12136793fi__nessed
fishinesses17107253fishinesses
fixednesses2244853fixednesses
flatnesses1337763flatnesses
foaminesses1658073foaminesses
fondnesses1437703fondnesses
forkinesses1848003forkinesses
formalnesses1744483formalnesses
fortresses1345663fortresses
foulnesses1337933foulnesses
foxinesses20127733foxinesses
fozinesses22158193fozinesses
freenesses1339873freenesses
fullnesses1336213fullnesses
fulnesses1239053f_ulnesses
furrinesses1437193furrinesses
germinesses1437883germinesses
glumnesses1344733glumnesses
gorinesses11311553gorinesses
griminesses14167573griminesses
hairinesses14198943hairinesses
hardnesses141810543hardnesses
harnesses121812073har_nesses
highnesses1746083highnesses
hipnesses1436753hi_pnesses
icinesses11310073_icinesses
iffinesses1635583iffinesses
illnesses937283_illnesses
ironnesses1047833_ironnesses
kermesses15284963kerm_esses
kindnesses1537213kindnesses
likenesses1449533likenesses
liminesses121310853liminesses
limpnesses14116653limpnesses
lionesses939433li_onesses
litenesses10513023litenesses
livenesses13411073livenesses
lornnesses1037823lornnesses
mildnesses1397393mildnesses
morenesses12811393morenesses
nicenesses12310353nicenesses
nighnesses1446463nighnesses
oilinesses101512443oilinesses
pertnesses12310313pertnesses
pinknesses1636583pinknesses
pipinesses1448603pipinesses
pixinesses1937373pixinesses
primenesses1548993primenesses
purenesses12810743purenesses
rarenesses10313113rarenesses
richnesses1537803richnesses
rifenesses1339953rifenesses
riminesses121211423riminesses
ripenesses12310383ripenesses
sicknesses1636763sicknesses
sizinesses1938653sizinesses
slimnesses1236423slimnesses
sorenesses101313493sorenesses
sprynesses1544973sprynesses
surenesses101212213surenesses
tartnesses101110713tartnesses
tidinesses1139223tidinesses
tininesses10311163tininesses
tirednesses1247743tirednesses
titanesses1037253titanesses
trignesses1188213trignesses
vilenesses13310223vilenesses
warinesses131514533warinesses
weirdnesses1545213weirdnesses
widenesses1438773widenesses
wildnesses14157363wildnesses
wilinesses131911093wilinesses
wirelesses1345333wirelesses
wisenesses13310823wisenesses
witnesses12219923wi_tnesses
worminesses16127993worminesses
wornnesses1337133wornnesses
wrynesses1534843_wrynesses

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 Filter1786911406030.470380193.6
2DLD Change Limit1406031177.96617650.4
3Display Results1171170.0631857.1
 (SQL Overall)1786911178.49921024.9
 
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.