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

194 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
genoises93925(None) 
genoise839421genoise_
enosises8311002_enosises
geneses82613522gen_eses
genies75324942gen_i_es
geniuses935932geniuses
genocides1344992genocides
genomes103611702geno_mes
gentiles93713522gentiles
genuses83510882gen_uses
gnoses76515162g_no_ses
kenosises1345142kenosises
noises65021852__noises
penises9318192pen_ises
tennises82810132tennises
adenoses947903adeno_ses
adonises92611433adonises
aegises8311373ae_gises
agencies1138743agenci_es
ageneses939303agen_eses
agenizes18269743agen_izes
agentives1346443agentives
agonises92613163agon_ises
anises64826693_an_ises
bennies93917313benni_es
benzines1938213benzines
betises94816123be_tises
canonises11410803canonises
cenobites1346203cenobites
cenotes92814543ceno_tes
censes83721803cen__ses
censuses10187543censuses
centeses1079443centeses
centiles103615813centiles
centimes124012613centimes
cercises12410933cercises
cerises94722253ce_rises
conioses10313313conioses
deixises1635693deixises
delouses9310013delouses
demises103719563de_mises
demonises12311093demonises
demoses103815823demo_ses
denies74729643den_i_es
denotes83817003deno_tes
dentines93418393dentines
dentists939263dentists
deposes103117213depo_ses
dermises112512023dermises
derrises93012783derrises
despises1139433despises
devises114116763de_vises
devoices14307413devoices
ebonises1039223_ebonises
egises7312493_e_gises
egoisms1065953_egoisms
egoists887073_egoists
encases93116053_encases
endites83717063_endites
endives113710693_endives
endorses959973_endorses
engines81114463_engines
enisles72312603_en_isles
enlists749393_enlists
enolases8411013_enolases
enosis63816423_eno_sis
ensiles72714833_ensiles
entases72816273_entases
entices91616333_entices
entires71517783_entires
envies9314053_envi_es
eonisms92811043_eonisms
eposes84418783_epo_ses
eroses65327053_ero_ses
etoiles7411293_etoiles
excises1638933_excises
finises10312903fin_ises
ganoids939323ganoi_ds
gaposises1245523gaposises
gemotes103712143gemo_tes
genes65133093gen___es
genesis82510823gen_esis
genettes938303genettes
genie66124923gen_i_e_
genips9469943gen_i_ps
genitives1346663genitives
genius74512923gen_i_us
genoas74013623geno__as
genocide1245693genocide_
genome94312193geno_me_
genomics1345713genomics
genoms94412483geno__ms
genotypes1544683genotypes
genres75515623gen__res
gentes75324163gen__tes
gentians937563gentians
gentile83515293gentile_
gentles83714343gen_tles
gentrices1258913gentrices
gentries91315263gentries
genuine838373genuine_
geodes8412153ge_o_des
geognosies1262673geognosies
geoids8369843ge_oi_ds
glacises1138503glacises
glosses84014123g_losses
gneiss765953g_neis_s
gneisses933673gneisses
gnomes93812973g_no_mes
gnomists1145473g_nomists
gnosis75711213g_no_sis
goonies83618333gooni_es
gooses75723053g__ooses
gorses74723293g__orses
grosses84517683g_rosses
grouses84616543g_rouses
guises74216313g__uises
gunfires1235063gunfires
gunites8313123gun_ites
gunnies83413123gunni_es
henhouses1546173henhouses
henries102718283henri_es
heroines112916573heroines
heroisms1338693heroisms
heroizes202610983heroizes
hexoses17228883hexo_ses
hoises94823673__hoises
incises93414893_incises
ionises72916433ion_ises
jennies143511623jenni_es
kenosis11369003keno_sis
kermises14248313kermises
ketoses114912873keto_ses
lenites7818443len_ites
lenses64620893len__ses
lentisks1244413lentisks
lewises1039133le_wises
lionises8310313lionises
mantises10317923mantises
meioses9310833meio_ses
melodises1247603melodises
memorises131211573memorises
menses84222453men__ses
merises93421423me_rises
noise55723733__noise_
noised75416233__noised
nooses65623643__nooses
noses55435643__no_ses
nouses64627163__nouses
ozonises1776373ozonises
peises84125043pe__ises
pelvises1337273pelvises
penalises11912753penalises
penlites10312263penlites
pennies94218813penni_es
pennines103112033pennines
penoches1538933penoches
pentoses10312893pentoses
peonies93620153peoni_es
peonisms1238443peonisms
poises84226543__poises
realises82420183realises
rehouses11312113rehouses
rejoices17287663rejoices
remises93423483re_mises
remorses10311993remorses
rennases848983rennases
reposes94021263repo_ses
reprises102615463reprises
reraises8415633reraises
rerises73525883re_rises
revises104220533re_vises
revoices13278993revoices
seises64026713se__ises
semioses10611013semioses
semises93916553se_mises
seniles72618023sen_iles
senores73218113seno_res
senses63923943sen__ses
stenoses8310443steno_ses
sunrises8310693sunrises
synopses1346223synopses
teniases838623teniases
tennies73017973tenni_es
tennists8297793tennists
tenorists948193tenorists
tenorites9311083tenorites
tenses64722553ten__ses
venines103516613ven_ines
venires103012453ven_ires
venose9310843veno_se_
venuses103111413ven_uses
xenopuses1843373xenopuses
xeroses143612823xero_ses

Search took 10 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.1561145455.1
2DLD Change Limit1461621948.94016349.2
3Display Results1941940.0762552.6
 (SQL Overall)1786911949.17219482.2
 
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.