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

115 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
hognoses1210814(None) 
hognose11117241hognose_
cognises11610042cognises
gnoses76515162__gnoses
hommoses1538162hommoses
hooknoses1644352hooknoses
hypnoses1646632hypnoses
prognoses1247532prognoses
zoonoses1746202zoonoses
adenoses947903adenoses
agonises92613163agonises
bigoses1039073big_oses
bongoes104314113bongo_es
bonuses94212953bo_nuses
chooses125717433cho__oses
cognates11311583cognates
cognise1059683cognise_
cognised1256313cognised
cognizes2058033cognizes
cognomen1346083cognomen
cognomens1443863cognomens
composes145017123composes
conenoses1188903conenoses
congoes103617303congo_es
conioses10313313conioses
connotes10311453connotes
cornuses10310033cornuses
cosmoses1239713cosmoses
cyanoses1337423cyanoses
diagnoses1145693diagnoses
doggones1135713doggones
doghouses1445353doghouses
ethnoses1146083ethnoses
geognosies1262673geognosies
gnomes93812973__gnomes
gnosis75711213__gnosis
gooses75723063__gooses
haggises1335883haggises
hanses95022633h_an_ses
haploses1338853haploses
hardnoses1346233hardnoses
hawknoses1942413hawknoses
heptoses1338373heptoses
hexoses17228893h_exoses
hidroses1237903hidroses
hobnobs1443603hobno_bs
hoboes114717453ho_bo_es
hocuses121710433ho_cuses
hocusses13155303hocusses
hogfishes1944683hogfishes
hogmanes1446783hogmanes
hognuts1134183hogn_uts
hogties112813993hog_ties
hogwashes1942463hogwashes
hoises94823683ho__ises
holloes103818193hollo_es
homosex1936133ho_mosex
hondles113614523ho_ndles
hones88144493ho_n__es
hongies112716473ho_ngies
honkies143015143ho_nkies
honored11310123ho_nored
honoree10412113ho_noree
honorees1148783ho_norees
honorer1039673ho_norer
honorers1139273ho_norers
honors94816793ho_no_rs
honours10339383ho_nours
hooknose1544273hooknose_
hooknosed1742413hooknosed
hoopoes121212483hoopo_es
hooves124815493ho__oves
hormones13311173hormones
hornists11208833hornists
hornless1137363hornless
horses94729353ho__rses
hoses85443183h___oses
hotboxes2045063hotboxes
hothouses1547763hothouses
hotness1038613hotnes_s
hotnesses1238903hotnesses
houses96032283ho__uses
hypnosis1646533hypnosis
ignores8269003_ignores
ionises72916433io_nises
ionones7313883io_nones
joneses1438963jo_neses
looses67328253lo__oses
lordoses937143lordoses
lotoses73713653lo_toses
mannoses1039083mannoses
mongoes103415713mongo_es
mongooses1285603mongooses
nonuses73313863no_nuses
nooses65623653no__oses
noses55435643___noses
onuses65616253_o_nuses
oogeneses1047853oogeneses
opposes1149243_opposes
osmoses9138133_osmoses
ostoses71213553_ostoses
prognose1146463prognose_
prognosed1344533prognosed
prognosis1246723prognosis
pycnoses1554973pycnoses
pyknoses1783573pyknoses
rhamnoses14104183rhamnoses
rooses65526243ro__oses
sorboses1038523sorboses
soroses73117493so_roses
stenoses8310443stenoses
tonuses73612193to_nuses
vaginoses1344143vaginoses
zoonosis1744393zoonosis
zygoses20436783zyg_oses

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 Filter1786911461620.470380193.6
2DLD Change Limit1461621158.04618165.8
3Display Results1151150.0462500.0
 (SQL Overall)1786911158.56220870.2
 
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.