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

229 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
genital84979(None) 
genial74917611geni_al
genitals937241genitals
agential958152agential
cental84420962cen_tal
denial74720512deni_al
dental74319172den_tal
geminal10109912geminal
general81010932general
genipap1243122genipap
genitalia1044022genitalia
genitalic1243922genitalic
genitally13127172genitally
genitival1343292genitival
genitor837272genitor
gentian8310102gentian
gentil74115122gen_til
geoidal936712geoidal
lanital7310912lanital
menial84223032meni_al
mental84521602men_tal
penial84120892peni_al
recital9412162recital
rental63922022ren_tal
venial94218282veni_al
xenial133414902xeni_al
zenithal2093332zenithal
aecial84817313aeci_al
aerial64625713aeri_al
agentival1353663agentival
animal85016253_animal
argental947933argen_tal
benthal1247953benthal
benzal1739643ben_zal
bestial9311643bestial
bonita8312943bonita_
bonitas939453bonitas
cantal84122033can_tal
capital112311523capital
censual937663censual
centai84814783cen_tai
centals94317053cen_tals
centas85020703cen_tas
central93114473central
chital114313883_chital
coital84117053_coital
congenital1345893congenital
conical11316203conical
cubital1137103cubital
cynical1437873cynical
decimal1238083decimal
denials84114133deni_als
dentals83915393den_tals
dentil74017883den_til
dentinal939503dentinal
detrital946573detrital
devisal1136913devisal
digital937063digital
edictal1046993_edictal
encinal949243_encinal
entail61114343_en_tail
entia5318203_entia_
epical10413393_epical
eugenical1245063eugenical
fecial114714623feci_al
ferial94621253feri_al
festal94213563fe_stal
fetal85623373fe__tal
fetial95716193feti_al
finial92814183fini_al
finical1239693finical
fontal9313143fon_tal
galenical1244683galenical
gametal1037603gametal
gavial10310083gavi_al
genera71211713genera_
generals9109333generals
generical1247003generical
genet66038683genet__
genetic101211783genetic
genetical1247583genetical
genets75716663genet_s
genette838863genette
geneva1085853geneva_
genevas1185253genevas
genially12129523genially
genic85119393geni__c
genically151110173genically
genie66124923geni__e
genies75324943geni_es
genii64514173geni__i
genip84415203geni__p
genipaps1342163genipaps
genips9469943geni_ps
genitive1247643genitive
genitors937423genitors
geniture946453geniture
genius74512923geni_us
genoa64315823gen_oa_
genoas74013623gen_oas
genocidal1343913genocidal
gent56954393gen_t__
genteel836753genteel
gentes75324163gen_tes
gentians937563gentians
gentile83515293gentile
gentle74014513gen_tle
gently103710913gen_tly
gentoo7311313gen_too
gentry103410443gen_try
gents65729613gen_t_s
genua64614153gen_ua_
geranial949283gerani_al
germinal1147263germinal
gestalt8411173ge_stalt
gestical1138993gestical
geta56627443ge__ta_
getas65421483ge__tas
gingal81010153gin_gal
gingival1342943gingival
glial66715433g_li_al
glottal835103glottal
gnathal1144353g_nathal
gonadal956523gonadal
gonia64117533goni_a_
gonidial1065943gonidial
granita82111303granita_
granitas92610223granitas
gremial1039153gremi_al
guitar7117443g_uitar
gunite7414403gunit_e
gunites8313123gunites
gunmetal1143213gunmetal
helical12311153helical
hematal1238953hematal
hernial10310433herni_al
initial7311883_initial
instal6712193_instal
invital1046953invital
irenical1048553irenical
lanitals837723lanitals
lenite6719983lenit_e
lenited8812433lenited
lenites7818443lenites
lenity9612713lenit_y
lentil64315393len_til
lexical1637363lexical
marital92314183marital
meatal84114733me_atal
medial93819863medi_al
medical12312513medical
menials94015683meni_als
meniscal1246203meniscal
mensal84615663men_sal
menta74424423men_ta_
mesial84818083mesi_al
metal75427383me__tal
metical11315363metical
minimal114010603minimal
natal53921493__natal
neonatal844383neonatal
nidal65217103__nidal
nival84915773__nival
nongenital1156683nongenital
nonvital1147023nonvital
notal55221353__notal
oedipal1045173oedipal
omental93210413omen_tal
orbital936923orbital
penal75228373pen__al
penicil1138833penicil
pentad9313763pen_tad
pentyl1138813pen_tyl
petal76526893pe__tal
pinitol936683pinitol
pregenital1345153pregenital
prenatal1048373prenatal
quintal16389883quintal
recitals1039763recitals
rectal84418133re_ctal
redial74923113redi_al
refutal1046943refutal
regental948943regen_tal
reginal84814293reginal
remittal1046513remittal
renal55929503ren__al
renewal1038703renewal
rentals74017473ren_tals
requital1745053requital
retial64724993reti_al
retinal75318353retinal
retotal739843retotal
revisal1038263revisal
revival1337033revival
scenical1247133scenical
segetal868383segetal
seitan62613233se_itan
seminal91213413seminal
sendal73314993sen_dal
seniti64317223senit_i
sensual738053sensual
septal84513383se_ptal
serial64625863seri_al
setal56430903se__tal
somital939403somital
spital83813873_spital
tectal83713253te_ctal
telial65815363teli_al
tenia55324483teni_a_
teniae64517353teni_ae
tenias64720073teni_as
tertial7313863tertial
ungenial946973ungeni_al
urogenital1152953urogenital
vegetal1156303vegetal
veinal93812963ve_inal
venal85523213ven__al
ventail10310453ven_tail
ventral103612173ventral
veritas103012753veritas
vesical12159813vesical
vestal94615573ve_stal
vital84819673__vital
xenia124814773xeni_a_
xenias133712973xeni_as
yenta83917043yen_ta_
yentas94614213yen_tas
zenith1839073zenit_h
zeniths1935153zeniths

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 Filter1786911340270.410435831.7
2DLD Change Limit1340272296.67020094.0
3Display Results2292290.0802862.5
 (SQL Overall)1786912297.16024956.8
 
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.