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

162 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
hayrides153688(None) 
hagrides1337621hagrides
hayride1437321hayride_
daysides1335962daysides
haeredes1246332haeredes
hagride1237552hagride_
hagrider1334482hagrider
hagriders1443552hagriders
halides113416662ha_lides
hardies114923232ha_rdies
harries103525492harri_es
hayricks2043762hayricks
haywires1744042haywires
hydrides16276942hydrides
joyrides1943852joyrides
waysides1544452waysides
abides94719893_a_bides
abrades10312073_abrades
abridges1245303_abridges
acrider1038623_acrider
acridest1138143_acridest
aeries64737783_aeri_es
aides65336603_a__ides
amides95722663_a_mides
aphides134711203_aphides
apsides103911303_apsides
arider74717743_a_rider
aridest8316143_a_ridest
arises65233803_a_rises
arrises71617583_arrises
arrives101311513_arrives
asides75118873_a_sides
azides165113803_a_zides
bardes95026933ba_r_des
barites94322333ba_rites
borides10515153_borides
brides94423513__brides
caprices1439893caprices
carbides133111693carbides
caribes113715643ca_ribes
carices114220953ca_rices
caries85147623ca_ri_es
carries94328013carri_es
charades141310853cha_rades
chlorides15289753chlorides
cyanides14258003cyanides
dairies84217733dairi_es
dayside1236173dayside_
daytimes1434483daytimes
debrides1268723debrides
derides93420853_derides
eyries93816813_eyri_es
faeries104118993faeri_es
fairies103516043fairi_es
farsides1237993farsides
gharries12318213gharri_es
grides84422363__grides
hackies163418243hacki_es
hades96035113ha___des
haeres94017033haer__es
hafizes2235983ha_fizes
haggises1335883haggises
hagridden1551623hagridden
hagrode1236443hagrode_
hairdos1136823hair_dos
hairier103111053hairi_er
hairiest11612473hairi_est
hairiness1238013hairiness
hairlines1237133hairlines
halide103417993ha_lide_
halids104016133ha_lid_s
halites103221193ha_lites
haloids113012553haloid_s
hankies143617763hanki_es
hapkidos1842713hapkidos
haplites1339993haplites
harden105718533ha_r_den
hardens113815023ha_r_dens
harder105022403ha_r_der
hardest113118413ha_r_dest
hardier114721543ha_rdier
hardiest123416343ha_rdiest
hards96435653ha_r_d_s
hares86255543ha_r__es
harmines132715143harmines
harpies123818323ha_rpies
harridan12145123harridan
harridans13154563harridans
harried113815533harri_ed
harrier104417753harri_er
harriers113712433harriers
hatreds11307813hatred_s
hawkies173311243hawki_es
hayings14379393hay_ings
haylages1536013haylages
hayracks2045313hayracks
hayrick1944183hayri_ck
hayseeds1543283hayseeds
haywire1644743haywire_
henries102718283henri_es
heredes11313133h_eredes
herries104025073herri_es
hides95129423h___ides
holytides1644743holytides
hordes104921633h_or_des
horrider1236533horrider
horridest1345643horridest
hubrises1337103hubrises
hurdies114015663h_urdies
hurries103919653hurri_es
hyalines14169333hyalines
hyalites14208833hyalites
hybrids16236023hybrid_s
hybrises1645423hybrises
hydride15257503hydride_
hydrids15267233hydrid_s
hyoids1377673h_yoid_s
hyraces1537913h_yraces
hyraxes2045703h_yraxes
irides74519123__irides
joyride1853753joyride_
joyrider1942663joyrider
joyriders2042233joyriders
kauries113613193kauri_es
kyries133411373_kyri_es
lapides103012043la_pides
latrines8515013latrines
marines93928013ma_rines
marrieds11288073marrieds
marries93825283marri_es
matrices12312083matrices
matrixes1738063matrixes
nitrides92910703nitrides
outrides92414993outrides
parades104121463pa_rades
paries84742513pa_ri_es
parises94827183pa_rises
parridges1384553parridges
parries93925843parri_es
paygrades1643623paygrades
prides94324183__prides
pyrites12812203_pyrites
pyxides2034423_pyxides
quaysides2243283quaysides
rachides141511223rachides
raphides14188393raphides
rawhides15145543rawhides
rhachides1853663rhachides
rides66140813___rides
sarodes84216143sa_rodes
satyrids1245623satyrid_s
sauries72821623sauri_es
sayids104310973say_id_s
sayyids14193833sayyid_s
strides84520393_strides
tacrines10310563tacrines
tardies84225863ta_rdies
tarries73324263tarri_es
taurines8310553taurines
varices123313573va_rices
varies94330873va_ri_es
wayside1435183wayside_

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621626.20323563.1
3Display Results1621620.0632571.4
 (SQL Overall)1786911626.67226782.2
 
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.