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

240 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
genoise83942(None) 
genoises939251genoises
genie66124922gen_i_e
genies75324942gen_ies
genoas74013622genoas_
genocide1245692genocide
genome94312192geno_me
genomes103611702genomes
genoms94412482genoms_
gentile83515292gentile
genuine838372genuine
noise55723732__noise
venose9310842veno_se
agencies1138743agencies
agenize172910153agen_ize
agentive1248043agentive
agonise83112693agon_ise
anise55129703_an_ise
arenose7311373areno_se
bendwise1443413bendwise
bennies93917313bennies
bennis84314803bennis_
benzine1839343benzine
betise85616273be_tise
canonise10511093canonise
cenobite1246853cenobite
cenote83715843ceno_te
cenotes92814543cenotes
cense75121403cen__se
centile94217183centile
centime114513033centime
cerise84822043ce_rise
concise11314473concise
delouse839833delouse
demise94618323de_mise
demonise11411933demonise
denies74729643den_ies
denote74118043deno_te
denotes83817003denotes
denotive1238673denotive
dense65923503den__se
dentine83320243dentine
dentist8316743dentist
depose94215763depo_se
despise1038683despise
devise104215753de_vise
devoice13347343devoice
ebonise939613_ebonise
eglomise1143933eglomise
egoism977473_egoism
egoist7612283_egoist
encase83714363_encase
endite73817593_endite
endive103310473_endive
endorse879203_endorse
endwise1136463_endwise
engine71114863_engine
enisle63412093_en_isle
enlist6417043_enlist
enokis103010273_enokis_
enolase7310193_enolase
enols54718403_enols_
enosis63816423_enosis
enosises8311003_enosises
enows85115493_enows_
ensile62616473_ensile
entice81316863_entice
entire61617703_entire
envies9314053_envies
envois988703_envois_
eonism83213533_eonism
erose55727273_ero_se
etoile6312263_etoile
excise1538553_excise
fanwise1336633fanwise
ganofs104010293ganofs_
ganoid8314443ganoi_d
ganoids939333ganoids
geese64316003ge__ese
gemlike14206813gemlike
gemote94613023gemo_te
gemotes103712143gemotes
gemots93712153gemots_
gene56237223gen___e
genes65133093gen_es_
geneses82613523gen_eses
genesis82510823genesis
genets75716663genets_
genette838863genette
genial74917613gen_ial
genic85119393gen_i_c
genii64514173gen_i_i
genip84415203gen_i_p
genips9469943gen_ips
genitive1247643genitive
genius74512923gen_ius
geniuses935933geniuses
genoa64315823geno__a
genocides1345003genocides
genom83716843geno__m
genomic1237923genomic
genomics1345713genomics
genotype1444483genotype
genre66016803gen__re
genres75515623genres_
genros74211333genros_
gens55740073gen__s_
gentes75324163gentes_
gentian8310103gentian
gentil74115123genti_l
gentiles93713523gentiles
gentle74014513gen_tle
gentles83714343gentles
gentoos838633gentoos_
gentrice1148813gentrice
gentries91315263gentries
gents65729613gen_ts_
genus65319833gen_us_
genuses83510883gen_uses
geode7412593ge_o_de
geodes8412153ge_odes
geoid74215763ge_oi_d
geoids8369843ge_oids
glenlike1334043glenlike
glenoid937803glenoi_d
gneiss765953g_neiss
gnome84213953g_no_me
gnomes93812973g_nomes
gnomish1345563g_nomish
gnomist1049133g_nomist
gnoses76515163g_no_ses
gnosis75711213g_nosis
gonofs10459863gonofs_
goonie73615563gooni_e
goonies83618333goonies
goose65925903g__oose
gorse65926813g__orse
grouse74315023g_rouse
guenons836563guenons_
guise64717713g__uise
gunfire1134743gunfire
gunite7414403gun_ite
gunnies83413123gunnies
gyrose105310253gyro_se
henhouse1445573henhouse
henlike1448693henlike
hennish1336863hennish
henries102718283henries
heroine103517483heroine
heroism12311013heroism
heroize193210963heroize
hexose16267843hexo_se
hoise85224773__hoise
incise83515333_incise
ionise63516943ion_ise
jennies143511623jennies
kenos95220623keno_s_
kenosis11369003kenosis
kenosises1345143kenosises
ketose105711813keto_se
lanose6313593lano_se
lenis56326863len_is_
lenite6719983len_ite
lenos56024863leno_s_
lense54523433len__se
lentisk1136063lentisk
leonine7311233leonine
lionise7310373lionise
manwise1239183manwise
melodise1147593melodise
memorise121411433memorise
mense75025633men__se
nicoise937923nicoise
noised75416233__noised
noises65021853__noises
noisy86813363__noisy
noose55624063__noose
nose46739363__no_se
nowise9511073__nowise
ozonise1646443ozonise
peise75825773pe__ise
penalise101013763penalise
penile82219603pen_ile
penis75129323pen_is_
penises9318193pen_ises
penlite9313243penlite
pennies94218813pennies
pennine93712953pennine
pennis84315743pennis_
penoche1447043penoche
pensile92713543pensile
pensive122610393pensive
pentose9311593pentose
peonies93620153peonies
peonism11611103peonism
poise75127893__poise
realise73021813realise
rehouse10311773rehouse
rejoice16287453rejoice
remise84221953re_mise
remorse9311713remorse
rennase738713rennase
renvois1036503renvois_
repose84121413repo_se
reprise92715043reprise
reraise7316313reraise
rerise64325633re_rise
rerose63320843rero_se
revise94019743re_vise
revoice12319183revoice
seise54727853se__ise
senile63420213sen_ile
senores73218113senores
senors63620793senors_
sense55526823sen__se
setose65114773seto_se
sunrise7310813sunrise
sunwise1036433sunwise
teniae64517353ten_iae
tennies73017973tennies
tennis64015303tennis_
tennises82810133tennises
tennist72813113tennist
tenons62916603tenons_
tenorist8413023tenorist
tenorite8311993tenorite
tenors63217753tenors_
tense55225843ten__se
tensile72612733tensile
tensive10269913tensive
tentie62521183tenti_e
tenuis64213083tenuis_
unnoisy1044243unnoisy
unwise9510803_unwise
venine93718433ven_ine
venire93513693ven_ire
venoms114211213venoms_
venous93713193venous_
wennish1336243wennish
xenons132710483xenons_

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 Filter1786911340270.423422437.4
2DLD Change Limit1340272405.89022755.0
3Display Results2402400.0932580.6
 (SQL Overall)1786912406.40627894.3
 
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.