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

167 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
noesises83850(None) 
coesites101313092coesites
ecesises1037022ecesises
enosises8311002eno_sises
loesses7310032loes_ses
nesses64718322n_es_ses
noesis6311442noesi__s
noises65021852no__ises
novelises1247372novelises
poesies93217402poesi_es
poetises10313952poetises
aegises8311373_aegises
andesites1048553andesites
besides104814533_besides
betises94816123_betises
blesses93812393bles_ses
bosses85925403bo_s_ses
bossies94116833bossi_es
bossisms1244703bossisms
brewises1337213brewises
cassises103811743cassises
cerises94722253_cerises
cesses84221363_ces_ses
chemises153211983chemises
chesses124112633ches_ses
clevises1336903clevises
coesite9713623coesite_
coexists1735653coexists
cognises11610043cognises
consists10310593consists
cosies84932163co_si_es
cosines94122673co_sines
cresses94219813cres_ses
demises103719563_demises
desires81316133_desires
desists83611723_desists
despises1139433_despises
devises114116763_devises
dosses76126273do_s_ses
dresses83716173dres_ses
egises7312493__egises
elegises9128823elegises
enuresises1043923enuresises
eosines73718293eo_sines
esses56422973__es_ses
fesses94820253_fes_ses
foetuses1136083foetuses
foresides1339703foresides
fosses96022083fo_s_ses
gneisses933673gneisses
guesses8169373gues_ses
hoises94823683ho__ises
homesites1448923homesites
inosines8312703ino_sines
inosites8312793ino_sites
iodises83413633io_dises
ionises72916433io_nises
itemises1087693itemises
jesses135215953_jes_ses
josses135117683jo_s_ses
kenosises1345143keno_sises
kneesies1245543kneesi_es
koumises1444593koumises
lewises1039133_lewises
lorises73918593lo_rises
losses65925233lo_s_ses
merises93421423_merises
messes84924343_mes_ses
mimesises1345363mimesises
missises103513693missises
monetises11311043monetises
morrises10711073morrises
mortises10713623mortises
mosses85527683mo_s_ses
mousses94012703mous_ses
neguses837933n_eguses
nemeses948663n_emeses
nestles73015463n_estles
newies91014073n_ewi_es
newsies101310393newsi_es
nexuses1436743n_exuses
noblesses1146003nobles_ses
noddies93512043noddi_es
noise55723733no__ise_
noised75416243no__ised
noisier759463noisi_er
noisiest839763noisiest
noisiness948353noisiness
nomisms11268743no_misms
noncrises11129313noncrises
nonissues943733nonissues
nonlives1138363nonlives
nonsenses948343nonsenses
nonuses73313863no_nuses
noogies82814583noogi_es
nookies113414963nooki_es
nooses65623653no__oses
norites74018803no_rites
nosedives1343713nosedives
noseless839513noseless
noses55435643no___ses
noshes96618233no_s_hes
nosier63716333no_si_er
nosiest73415673no_siest
nosiness83211393no_siness
nosings8349593no_sings
notecases1145173notecases
notices9312283no_tices
nourishes12116733nourishes
nouses64627163no__uses
novelise1137953novelise_
novelised1344983novelised
novelists1245933novelists
novelizes2146223novelizes
novices1238223no_vices
nowise9511073no_wise_
nownesses1236893nownes_ses
obelises1039103obelises
orrises71312233_orrises
oyesses1037333oyes_ses
peises84125043_pe_ises
penises9318193_penises
poetise9314043poetise_
poetised1138523poetised
poetiser1037313poetiser
poetisers1145313poetisers
poetizes19310253poetizes
poises84226543po__ises
popsies112816473popsi_es
posies84431433po_si_es
posses85128803po_s_ses
potsies93019483potsi_es
poussies1038113poussies
precises123218333precises
premises123018273premises
presides11414913presides
presses93523153pres_ses
previses133814283previses
remises93423483_remises
rerises73525883_rerises
resides84523283_resides
resiles74026543_resiles
resists74414923_resists
resites74027793_resites
resizes164216843_resizes
revises104220533_revises
rhesuses1134893rhesuses
seises64026713_se_ises
semises93916553_semises
sises55233833___sises
skepsises1542753skepsises
solecises1189103solecises
sorosises947303sorosises
soubises10107993soubises
speises93813933spe_ises
speisses10245693speisses
syndesises1443563syndesises
synesises1245613synesises
toeshoes1147713toeshoes
topsides1137203topsides
tosses65225393to_s_ses
tresses73719543tres_ses
tussises835433tussises
whoosises1543423whoosises
whosises1435333whosises
yesses93615813_yes_ses
zoisites1744973zoisites

Search took 8 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.423422437.4
2DLD Change Limit1461621676.97020970.2
3Display Results1671670.0762197.4
 (SQL Overall)1786911677.46923924.4
 
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.