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

196 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
hurrays1338615(None) 
hurrahs13336771hurrahs
hurray12459911hurray_
arrays95311682_arrays
currans9310612currans
durras74713372durra_s
hoorays13418372hoorays
hurleys13407332hurleys
hurrah12369182hurra_h
hurrayed1543042hurrayed
hurries103919652hurries
hurry114917182hurr_y_
murras84916002murra_s
murreys12367322murreys
sunrays1037082sunrays
surras65919532surra_s
surreys10489442surreys
affrays1644063affrays
airways1336243airways
arras55626133_arra_s
array86317143_array_
auras55932553au_ra_s
auroras7311703aurora_s
betrays12127823betrays
bewrays15145113bewrays
brays106723113__brays
burans85019303bu_rans
buras74736293bu_ra_s
bureaus979293bureaus
burials93612083burials
burkas124513803burka_s
burlaps1156253burlaps
burleys12479673burleys
burqas174410903burqa_s
burrers93814493burrers
burros85114993burr_os
burrows12399093burrows
burrs74925653burr__s
burry105221563burr_y_
bursars94510893bursars
bursas85318273bursa_s
churros12427583churr_os
churrs115111513churr__s
corrals93713853corrals
cuirass934973cuirass
cullays12347703cullays
curaras93911953curaras
curares94916853curares
curaris94114773curaris
currach1446453currach
currachs1544543currachs
curragh1344293curragh
curraghs1442883curraghs
curran8312023curra_n
currant9314173currant
currants1037933currants
curries93723163curries
currs75624393curr__s
curry105920343curr_y_
curtals93111623curtals
defrays1436113defrays
derays105514253_derays
dhourras1252233dhourra_s
dhurnas1153443dhurna_s
dhurries1255583dhurries
drays95819773__drays
duras65727723du_ra_s
durbars1077973durbars
durians839573durians
durra65315793durra__
durries83817353durries
durrs65519993durr__s
estrays10529403estrays
forays124813003_forays
frays116920103__frays
furans94515953fu_rans
furrows13327793furrows
furry116719283furr_y_
grays95621333__grays
guanays1134953guanays
gurneys11406463gurneys
gurries83515953gurries
gurry94515413gurr_y_
harass9313943h_arass
hardass1139753hardass
harries103525493harries
harrows132611033harrows
harry115322953harr_y_
hartals10313023hartals
hays106138073h___ays
hearsays1444513hearsays
henrys12366103henr_ys
herbals122710603herbals
herries104025073herries
herry114922473herr_y_
heydays1734143heydays
hijrahs2043443hijrahs
hijras1635773hijra_s
hoorahs13399603hoorahs
hooray123011373hooray_
horahs126313873h_orahs
horary12310383horary_
horas86333103h_ora_s
horrors1078693horrors
hubcaps1643543hubcaps
hubris11218973hubr_is
hulas84920883hu_la_s
humans112312433hu_mans
humerals1347173humerals
hunkeys17386193hunkeys
huppahs1743333huppahs
hurdies114015663hurdies
hurdles113613373hurdles
hurds95219073hu_r_ds
hurlers103714323hurlers
hurley125012523hurley_
hurlies103315333hurlies
hurls86522713hu_r_ls
hurly115819293hu_rly_
hurrahed1543463hurrahed
hurraying1654323hurraying
hurried113511043hurried
hurrier103412943hurrier
hurriers11358893hurriers
hursts97213093hu_rsts
hurters103413643hurters
hurtles103913753hurtles
hurts86922823hu_r_ts
hussars10326983hussars
huzzahs2143083huzzahs
huzzas1735863huzza_s
hydras13239313hydra_s
jarrahs1735453jarrahs
jurats134213203ju_rats
kurgans12145653kurgans
kurtas10349883kurta_s
lurdans837073lurdans
margays1337493margays
marrams11310123marrams
morays114613883_morays
mudras94212253mudra_s
murals84016753mu_rals
muras75329563mu_ra_s
murra74519083murra__
murrain937763murrain
murrains1036853murrains
murres85019043murr_es
murrey114312263murrey_
murrhas12286173murrhas
murries94118673murries
murrs75521293murr__s
murry105120233murr_y_
orfrays1343533orfrays
ouraris73512933ouraris
outlays102610903outlays
outprays13236933outprays
outsays102710403outsays
parlays123910453parlays
parrals94414573parrals
portrays1345293portrays
prays105022433__prays
purdahs13285483purdahs
purdas92612263purda_s
purrs75320433purr__s
purveys15615903purveys
quays174612043qu__ays
rays77642353___rays
runways13134443runways
sirrahs10377303sirrahs
sirras63814863sirra_s
sprays115913643_sprays
spurreys13364603spurreys
strays96417933_strays
subways1536163subways
sunray9310123sunray_
surahs94515543su_rahs
suras55336323su_ra_s
surpass938283surpass
surra55521343surra__
surrey94414583surrey_
surveys13357573surveys
sutras64818593sutra_s
terras63516973terra_s
thruways1742503thruways
trays85623433__trays
turbans939563turbans
turkeys1434523turkeys
turrets73010673turrets
unlays93810493_unlays
unsays9399543_unsays
urares64519093_urares
uraris63817273_uraris
ureas55826013_urea_s
urials64415193_urials
vouvrays1741373vouvrays
whiprays1942503whiprays

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271966.65620136.3
3Display Results1961960.0633111.1
 (SQL Overall)1786911966.87525991.4
 
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.