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

153 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
hayride143732(None) 
hagride1237551hagride
hayrides1536881hayrides
dayside1236172dayside
hagrider1334482hagrider
hagrides1337622hagrides
hagrode1236442hagrode
halide103417992ha_lide
harried113815532harried
hayrick1944182hayrick
haywire1644742haywire
hydride15257502hydride
joyride1853752joyride
wayside1435182wayside
abide86223713_a_bide
abrade9313053_abrade
abridge1135693_abridge
acrid86920103_acrid_
acrider1038623_acrider
aerie54634603_aeri_e
aeried74221863_aeried
aide56044993_a__ide
amide86128483_a_mide
arid57642713_a_rid_
arider74717743_a_rider
arise56436433_a_rise
arrive91311793_arrive
aside65122083_a_side
astride8311973astride
azide155617163_a_zide
barde85330773ba_r_de
barite84224813ba_rite
boride9415903_boride
bride86425533__bride
caprice1349683caprice
caprine11314233caprine
carbide126112493carbide
caribe103416753ca_ribe
caried94528693ca_ried
carried103717153carried
charade13129913cha_rade
chloride143310243chloride
cyanide13298843cyanide
daysides1335963daysides
daytime1344783daytime
debride1138593debride
deride84420033_deride
eyrie88117833_eyri_e
faerie93514683faeri_e
farside1138603farside
gride75223583__gride
habile11515213ha_bile
hackie154615623hacki_e
hade85440193ha___de
haeredes1246333haeredes
hagridden1551623hagridden
hagriders1443553hagriders
hairdo1036433hair_do
haired105117173haired_
hairier103111053hairier
hairlike1536673hairlike
hairline1137873hairline
halid94424983ha_lid_
halides113416663ha_lides
halids104016133ha_lids
halite93624233ha_lite
haloid104317763haloid_
haloids113012553haloids
hankie133915713hanki_e
hapkido1743143hapkido
haplite12310703haplite
hard85443503ha_r_d_
harden105718533ha_r_den
harder105022403ha_r_der
hardier114721543ha_rdier
hardies114923233ha_rdies
hards96435653ha_r_ds
hardy125622063ha_r_dy
hare76255733ha_r__e
hared95742183ha_red_
haring104233003ha_ring
harked145422553ha_rked
harmed125218833ha_rmed
harmine122816193harmine
harped124418403ha_rped
harridan12145123harridan
harrier104417753harrier
harries103525493harries
hatlike143311713hatlike
hatred104814333hatred_
hatreds11307813hatreds
hawkie163810093hawki_e
hayed125822013hay_ed_
haying134420613hay_ing
haylage1436443haylage
hayrack1945543hayrack
hayricks2043763hayricks
hayseed1435633hayseed
haywires1744043haywires
herried113514453herried
hide85134633h___ide
holytide1544973holytide
horde94623053h_or_de
horrid10311563horrid_
horrider1236533horrider
hurried113511043hurried
hyaline132310723hyaline
hyalite13229473hyalite
hybrid15237813hybrid_
hybrids16236023hybrids
hydriae14246903hydriae
hydrid14248973hydrid_
hydrides16276943hydrides
hydrids15267233hydrids
hyoid12612443h_yoid_
hyoids1377673h_yoids
joyrider1942663joyrider
joyrides1943853joyrides
joyrode1853303joyrode
kyrie123712903_kyri_e
larine63927043la_rine
latrine7715123latrine
marine84230403ma_rine
married104715303married
narine63422553na_rine
nitride82811243nitride
outride82615683outride
papyrine1546053papyrine
parade94720643pa_rade
pardie96021443pa_rdie
parridge1254333parridge
parried103615723parried
paygrade1543593paygrade
pride84724733__pride
pyrite11913313_pyrite
quayside2143473quayside
raphide13138073raphide
rawhide14134973rawhide
raylike14269253raylike
ride55945123___ride
sarode75317513sa_rode
satyrid1137233satyrid_
satyrids1245623satyrids
sayid95516723say_id_
sayids104310973say_ids
sayyid13185353sayyid_
sayyids14193833sayyids
stride75420963_stride
tacrine9311293tacrine
tarried83914133tarried
taurine7311363taurine
varied104817863va_ried
waysides1544453waysides

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.1561145455.1
2DLD Change Limit1340271537.42318055.6
3Display Results1531530.0463326.1
 (SQL Overall)1786911537.62523434.9
 
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.