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 “highnesses” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
highnesses174608(None) 
nighnesses1446461nighnesses
bignesses1267952big_nesses
highness1536052highne_s_s
hipnesses1436752hi_pnesses
hugenesses1437132hugenesses
lightnesses1546142lightnesses
richnesses1537792richnesses
rightnesses1546232rightnesses
tightnesses1565582tightnesses
airinesses102613603airinesses
apishnesses1646373apishnesses
archnesses1547173archnesses
biasnesses1236943biasnesses
brightnesses1844183brightnesses
caginesses13310933caginesses
chicnesses1745203chi_cnesses
chillnesses1644713chillnesses
digeneses1147393digene_ses
digresses1137863dig_resses
dimnesses1238213di_mnesses
dinginesses1337473dinginesses
direnesses11311483direnesses
edginesses1236683edginesses
finenesses13310713finenesses
finesses111912333fi__nesses
firmnesses1535613firmnesses
fishinesses17107233fishinesses
fitnesses12219373fi_tnesses
hairinesses14198943hairinesses
halenesses13312033halenesses
halfnesses1636263halfnesses
hardnesses141810543hardnesses
harnesses121812073h_arnesses
harshnesses1745853harshnesses
hazinesses2239213hazinesses
highrises1644633high_rises
hillinesses1458503hillinesses
hippinesses1845493hippinesses
hokinesses1758933hokinesses
holinesses13511483holinesses
hominesses15510843hominesses
hotnesses1238903h_otnesses
icinesses11310053_icinesses
illnesses937273_illnesses
kindnesses1537213kindnesses
likenesses1449533likenesses
liminesses121310843liminesses
limpnesses14116653limpnesses
lionesses939423li_onesses
litenesses10513003litenesses
lithenesses1447303lithenesses
livenesses13411053livenesses
loginesses11410313loginesses
lushnesses1337333lushnesses
mightinesses1844383mightinesses
mildnesses1397393mildnesses
mirinesses121512303mirinesses
muchnesses1744693muchnesses
nicenesses12310333nicenesses
nighness1236103nighne_s_s
oilinesses101512433oilinesses
pigginesses1555613pigginesses
pinknesses1636583pinknesses
pipinesses1448593pipinesses
pithinesses1637503pithinesses
pixinesses1937363pixinesses
poshnesses1537453poshnesses
rashnesses1338713rashnesses
rifenesses1339933rifenesses
rigidnesses1345923rigidnesses
riminesses121211403riminesses
ripenesses12310363ripenesses
roughnesses15105133roughnesses
sagenesses11510823sagenesses
shininesses1448293shininesses
sicknesses1636753sicknesses
sizinesses1938643sizinesses
slightnesses1654623slightnesses
suchnesses1536653suchnesses
thicknesses2043903thicknesses
thingnesses1545173thingnesses
thinnesses1346253thi_nnesses
tidinesses1139213tidinesses
tigresses1046403tig_resses
tininesses10311153tininesses
titanesses1037233titanesses
toughnesses15104483toughnesses
trignesses1188213trig_nesses
vilenesses13310213vilenesses
whininesses1746183whininesses
whitenesses1746633whitenesses
widenesses1438773widenesses
wildnesses14157363wildnesses
wilinesses131911083wilinesses
wirinesses131811513wirinesses
wisenesses13310803wisenesses
witnesses12219923wi_tnesses

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.1561145455.1
2DLD Change Limit140603985.81024200.2
3Display Results98980.0462130.4
 (SQL Overall)178691986.01229722.4
 
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.