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 “horizontal” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

236 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
horizontal225190(None) 
horizonal2153001horizon_al
horizontals2351541horizontals
horizontally2761942horizontally
horizon1955763horizon___
horizons2045463horizon__s
horizontality2861703horizontality
hormonal1346643hor_mon_al
oriental848493_ori_ental
baritonal1144684bariton_al
bizonal1845564__bizon_al
confrontal1553784confrontal
coronal94115764cor__on_al
frontal1038364_fr__ontal
horizonless2391204horizonless
horntail11105034hor___ntail
motional1058674moti_on_al
notional849404noti_on_al
orientals946924_ori_entals
original956794_origin_al
periodontal1463164periodontal
peritoneal1255114peritoneal
torsional945034torsion_al
tridental1046634_tridental
trigonal946244_trigon_al
aboriginal1352105aborigin_al
accidental1553815accidental
alimental1155875_alimental
antidotal1046135antido_tal
antimonial1248395antimonial
aortal65217515aor____tal
argental947935_ar_gental
azonal1568275___azon_al
baronial1049485bar__onial
bidental1146595__bidental
borstal939045bor___stal
carinal94318245cari__n_al
ceremonial1464385ceremonial
chorial124214145chori____al
chorion12311775chori_on___
chorionic1646495chori_on_ic
chorions13310665chori_on__s
chorizo2136325chorizo____
chorizos2245495chorizo___s
choroidal1544675chor__oidal
cliental1045365_cli_ental
coital84117055co_i___tal
coitional1148695coition_al
colonial10411345co__lonial
condimental1655495condimental
confrontals1652665confrontals
continental1375655continental
corneal94414505cor___neal
cornual94210175cor___nual
corona83817405cor__on_a_
coronae94214895cor__on_ae
coronals103312915cor__on_als
coronas93916915cor__on_as
coronate103018215cor__onate
coronel94515225cor__on_el
corporal1248515cor_po_ral
corporeal1344985cor_poreal
coryzal2154825coryz___al
cottontail1251975co_ttontail
covenantal1552455covenantal
criminal1248305_crimin_al
crinoidal1254425_crinoidal
detrimental1454855detrimental
documental1554515documental
dorsiventral1661415dorsiventral
emotional1146665emoti_on_al
eobiont959945eobi_ont__
eobionts1043985eobi_ont_s
erosional946625erosion_al
fontal9313145____fontal
foraminal1444265foramin_al
forestal11410285for__estal
forint9325025fori__nt__
forints10411835fori__nt_s
frontals1146275_fr__ontals
fusional1145075fusi_on_al
gorgonian1142755gor_gonian
hariana10310245hari_an_a_
harianas1139175hari_an_as
haricot12311965harico_t__
haricots1347335harico_t_s
hartal9415485har____tal
helicoidal1652985helicoidal
heliconia1453825heliconia_
heliconias1553865heliconias
heliostat12104895heli_ostat
hemiacetal1752115hemiacetal
heriot9422345heri_o_t__
heriots10312065heri_o_t_s
hernial10310435her___nial
heroical13410025her__oical
hexagonal2062665hexagon_al
hiatal9310205h__i__atal
homicidal1743875homi_cidal
hominian1357095homi__nian
homosocial1753645homosocial
horal86328685hor_____al
hordeola1244735hordeo_la_
horizontalities2771765horizontalities
hormogonia1653175hormogonia_
hormonally1844535hor_monally
hormone12410505hor_mon__e
hormones13311175hor_mon_es
hormonic1568155hor_mon_ic
hornpout1356705hornpout__
hornpouts1443455hornpout_s
horntails12124825hor___ntails
hornwort1447795hornwort__
hornworts1544395hornwort_s
horological1748285horological
horrent10313555hor_rent__
horsetail1244695hor__setail
hospital1344755ho__spital
houstonia1253385houstonia_
houstonias1353355houstonias
incidental13135625incidental
intrazonal1954005intrazon_al
irridenta1063925irridenta_
irridentas1163455irridentas
marital92314185mari___tal
matrimonial1552775matrimonial
meridional1353555meridion_al
monitorial1246735monitorial
monsoonal1144055monsoon_al
monumental1455215monumental
morainal1047205mor_ain_al
morion86217735mori_on___
morions94014645mori_on__s
mortal84616855mor____tal
national8311535nati_on_al
nominal92712375nomi__n_al
nonagonal1055275nonagon_al
noncoital1148595no_ncoital
nonmental11410865no_nmental
nonmortal1146495no_nmortal
nonpostal1145915no_npostal
nontonal849745no_nton_al
occidental1553605occidental
octantal1044565_o_ctantal
omental93210425_o__mental
oogonial945255_o_ogonial
optional1047645_option_al
orbital936925_or__bital
ordinal838645_or_din_al
orient6322535_ori_ent__
orientally1346215_ori_entally
orientate946515_ori_entate
oriented937485_ori_ented
orienter838315_ori_enter
orients7311585_ori_ent_s
orificial1444375_orificial
originals1044845_origin_als
originate1047025_originate
orinasal843565_ori_nasal
orison6411665_orison___
orisons7310565_orison__s
ornamental1264645_ornamental
oviductal1551275_oviductal
ozonate1646865_o__zonate
parental10310955par__ental
parietal1048785pari__etal
patrimonial1553415patrimonial
pedimental1556435pedimental
percental1348675per_cental
pericopal1545815perico_pal
perinatal1146485peri_natal
perineal1049205peri__neal
periosteal1253595peri_osteal
peritonea1147305peritonea_
peroneal1049175per__oneal
personal102311575per_son_al
pheromonal1754265pheromon_al
pivotal1245435__pivo_tal
polygonal1544345polygon_al
polytonal1444925polyton_al
poriferal1444045pori_feral
portal84218465por____tal
positional1247905position_al
postcoital1453495postcoital
precoital1347275_precoital
prefrontal1552605prefrontal
primatal1247135_pri_matal
pyridoxal2252135pyrido_xal
quintal16389885_qui__ntal
rational8412545rati_on_al
recountal1144195__recountal
regental948955__regental
regimental13115775regimental
regional9438785regi_on_al
rental63922035__r__ental
retotal739845__reto_tal
rhizobial2351705_rhizobial
rhizoidal2252315_rhizoidal
ricotta955435__ricotta_
ricottas1044465__ricottas
rictal83113195__ri__ctal
rudimental1353835rudimental
schizont2244715schizont__
schizonts2342465schizont_s
scrotal938495scr__o_tal
semipostal1453425semipostal
semitonal1157045semiton_al
societal1045725soci__etal
somital939405somi___tal
sonantal886265so__nantal
sororal7310655sor__o_ral
sporozoal20113205sporozo__al
springal1145975spri__ngal
tormentil1144225tor_mentil
toroidal966395tor__oidal
torrential1054485tor_rential
tribunal10104675_tribun_al
triennial945075_triennial
trifocal1345035_trifo_cal
trilobal1044375_trilo_bal
trimonthly1851935_trimonthly
trinal6516965_tri__n_al
trinodal945445_trino_dal
trinomial1156235_trinomial
tripodal1145145_tripo_dal
unisonal845375_unison_al
unoriginal1152755unorigin_al
uprootal1043455upr__ootal
urinal6614125_uri__n_al
varietal1145615vari__etal
versional1245865version_al
virilocal1452105virilo_cal
visional1146665visi_on_al
volitional1345415volition_al
zonal145116855____zon_al
zoonal1558085zo___on_al

Search took 19 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 Filter1786911735450.466383457.1
2DLD Change Limit17354523617.8009749.7
3Display Results2362360.1102145.5
 (SQL Overall)17869123618.3769724.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.