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

294 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
hydro1225942(None) 
hydra12249221hydra
hydros13279361hydros
andro6314162andro
gyro85217882gy_ro
hadron102913752hadron
hero74635782h_ero
hydrae13258572hydrae
hydras13239312hydras
hydria13227902hydria
hydric15227952hydric
hydrid14248972hydrid
hydroid1539712hydroid
hydrops16197412hydrops
hydrous14197882hydrous
hydroxy2454262hydroxy
hypo127516352hy_po
pedro8313152pedro
pyro96019392py_ro
tyro76622362ty_ro
ado49146873_ad_o
aero45435343_aero
aggro738013aggro
andros7313303andros
ardor64617863ardor
audio62917103audio
biro66131213_biro
bro56236603__bro
burro75018493burro
byre95023853by_re
byrl95716013by_rl
cadre85419023cadre
cero66329453_cero
chador1238673chador
chadri1238143chadri
charro114212953charro
cheero114712933cheero
chiro105320343chiro
churro11448353churro
claro75018693claro
cyano105512493cyano
cyclo1237703cyclo
cyder114611133cyder
cyders12398833cyders
dado67126333dad_o
dido66528203did_o
do310155253__d_o
dobro84412213dobro
dodo66024913dod_o
dor47253923__dor
drop75324403__drop
dry76526033__dry
duo48536143__duo
duro56228023_duro
dyer85522113dyer_
dyers96617133dyers
eddo63411803_eddo
enduro7338623enduro
euro45325273_euro
eyer76127283eyer_
eyers86521333eyers
eyra76217553ey_ra
eyre75525253ey_re
eyry106315883ey_ry
fado87226463fad_o
faro76136923_faro
fido87726403fid_o
fordo97218653fordo
fro65530643__fro
gadjo1436913gadjo
genro64914033genro
giro55828633_giro
guiro63712093guiro
gyre84722763gy_re
gyri85415153gy_ri
gyron95314623gy_ron
gyros95616483gy_ros
haar77323493haar_
haars85620473haars
had77658763had__
hadal95518123hadal
hade85440193had_e
haded105227623haded
hades96035113hades
hadj155818673had_j
hadji16839893hadji
hadrons113314303hadrons
hadst93220223hadst
hair76330143hair_
hairdo1036433hairdo
hairs86225173hairs
hairy115316833hairy
hallo85127553hallo
halo76437323h_alo
hao67251123h__ao
hard85443503h_ard
hards96435653hards
hardy125622063hardy
hare76255733h_are
hark115237393h_ark
harl75740003h_arl
harm95637793h_arm
harp96134293h_arp
harrow122610773harrow
harry115322953harry
hart76865773h_art
hayer114620243hayer_
hayers124415943hayers
hear76143883hear_
heard95222753heard
hears86737373hears
heart85440743heart
heder95623643heder
heders104119763heders
hedge105317353hedge
hedgy134510753hedgy
heir77523803heir_
heirs85618563heirs
helio85321193helio
hello86522983hello
helo75332853h_elo
henry114014473henry
her66547813h_er_
herb94730963h_erb
herd84933063h_erd
herds96424683herds
here76447103h_ere
herl75834553h_erl
herm95636153h_erm
hern76134893h_ern
heron85025503h_eron
heros84930863h_eros
herry114922473herry
hers75844873h_ers
hetero9312633hetero
heyday1635143heyday
heydey1634633heydey
hid76248383hid__
hide85134643hid_e
hided105222443hided
hider95024083hider
hiders104919653hiders
hides95129423hides
hijra1535643hijra
hillo84721653hillo
hippo12369063hippo
hire75538963h_ire
ho510258273h___o
hoar76729163hoar_
hoard94918313hoard
hoars85925553hoars
hoary114516763hoary
hobo97026083h_obo
hod76852463hod__
hodad10311353hodad
hods87239863hod_s
hoer76533983hoer_
hoers85724923hoers
hollo84822163hollo
homo96126473h_omo
honor85718623honor
hoodoo10109983hoodoo
hora76136563h_ora
horde94623053horde
horn76735613h_orn
horror988723horror
hotrod1048803hotrod
hour75827313hour_
houri85915253houri
hours85422393hours
hoyden13328933hoyden
hullo84417453hullo
humor101110513humor
hurds95219073hurds
hurl76029933h_url
hurry114917183hurry
hurt77142573h_urt
hybrid15237813hybrid
hybris14247003hybris
hydragog1743053hydragog
hydrant1489053hydrant
hydrase14287663hydrase
hydrate14239813hydrate
hydrator1545763hydrator
hydriae14246903hydriae
hydride15257503hydride
hydrids15267233hydrids
hydrogel1644753hydrogel
hydrogen1646283hydrogen
hydroids1647763hydroids
hydromel1795353hydromel
hydronic1748093hydronic
hydropic1947273hydropic
hydropsy20184153hydropsy
hydroski1943523hydroski
hydrosol1544473hydrosol
hydroxyl2543883hydroxyl
hyena11810253hyena
hying126514743hying
hyla106716513hy_la
hylas114815903hylas
hymen13311043hymen
hymn12311313hy_mn
hymns1337523hymns
hyoid12612443hyoid
hyp117822463hy__p
hype125519813hy_pe
hyped145313333hyped
hyper135213903hyper
hyperon1548183hyperon
hypers144811913hypers
hypes135818673hypes
hypha1637383hypha
hypos1312014743hypos
hyps125418413hy_ps
hyrax1838033hyrax
hyson1138693hyson
hyssop1443413hyssop
hyte109018943hy_te
indri6310793indri
inro45920793_inro
intro54915853intro
judo125315303jud_o
kiddo11398953kiddo
kudo96115113kud_o
kyar116916843kyar_
kyars124813963kyars
ladron73413323ladron
lido56028163lid_o
lyard95113213lyard
lyart85121883lyart
lycra10317973lycra
lyre75623793ly_re
macro94718173macro
madre85720173madre
maduro936983maduro
metro74718803metro
micro94715993micro
morro73216953morro
mucro94513723mucro
mudra83912433mudra
myrrh1337093myrrh
nitro54914353nitro
odor55718093_odor
ordo54622353ord_o
oyer75927653oyer_
oyers87620883oyers
padre86018163padre
padri85815173padri
pedros9312183pedros
phyllo1435873phyllo
pro55837263__pro
pyre94925553py_re
pyros105718293py_ros
pyrrol1136273pyrrol
radio64922493radio
redo56029363red_o
redry94314363redry
repro75315913repro
retro55020953retro
rodeo65921093rodeo
shyer114714783shyer_
shyers124712203shyers
sudor6312623sudor
sybo9714743sy_bo
tardo65321103tardo
taro46846913_taro
thoro86217873thoro
thro77726423_thro
tiro46832363_tiro
toro48045683_toro
tyer75323393tyer_
tyers86220053tyers
typo95418123ty_po
tyre75428253ty_re
tyros85118593ty_ros
udo49027303_ud_o
undo55620153und_o
updo76712883upd_o
updry1135483updry
video96014953video
whydah1942953whydah
yar67253833_yar_
yard85633253_yard
yare75636943_yare
yarn75230043_yarn
yerk116222083_yerk
yird87018983_yird
yirr76513573_yirr
yo59748553_y__o
yore76335943_yore
yurt76435043_yurt
zero134822473_zero
zydeco2142493zydeco

Search took 4 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 Filter178691836670.343520965.0
2DLD Change Limit836672943.15626510.5
3Display Results2942940.0803675.0
 (SQL Overall)1786912943.57949927.6
 
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.