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

379 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
hurleys1340733(None) 
burleys12479671burleys
hurlers103714321hurlers
hurley125012521hurley_
barleys125011842barleys
burlers94120272burlers
burley114715752burley_
charleys1695632charleys
curlers94218072curlers
curlews12387392curlews
furlers104214222furlers
furless103210142furless
gulleys11438522gulleys
gurneys11406462gurneys
henleys1334842henleys
hueless1058822hueless
hullers103616262hullers
hunkeys17386192hunkeys
hurdlers12337492hurdlers
hurdles113613372hurdle_s
hurled104617452hurle_d
hurler94717222hurle_r
hurlies103315332hurlies
hurls86522712hurl__s
hurly115819292hurl_y_
hurrays13386152hurrays
hurters103413642hurters
hurtles103913752hurtle_s
hurtless11307782hurtless
muleys11409642mu_leys
mulleys12299202mulleys
murreys12367322murreys
parleys125212372parleys
pulleys12399142pulleys
purveys15615902purveys
pusleys12286232pusleys
surreys10489432surreys
surveys13357572surveys
turkeys1434522turkeys
airless73712043airless
alleys95113303_alleys
arles56735743_arle_s
auklets11298573auklets
aures55137093aur_e_s
aureus65314883aur_eus
baileys12388933baileys
barless94317003barless
barley115116763barley_
barneys12569563barneys
birlers93813003birlers
birles84920643birle_s
budless1038873budless
buglers105115323buglers
bugles94822443bugle_s
bullets93516393bullets
burblers12399263burblers
burbles114916803burble_s
burdens1039713burdens
burets84321263bur_ets
burgees104915893burgees
burgers103918573burgers
burgess10409343burgess
burgles105615963burgle_s
buriers94017193buriers
buries84633273burie_s
burkers133716623burkers
burkes124421313burke_s
burlaps1156253burlaps
burled94825383burle_d
burler84723833burle_r
burlesk1335463burlesk
burlesks1443223burlesks
burls74228853burl__s
burly104922833burl_y_
burners94115673burners
burnets93813263burnets
burrers93814493burrers
burses84425513burse_s
butlers94518053butlers
butles84423913butle_s
carles85435083carle_s
carless95118493carless
carneys124310543carneys
charley15118273charley_
chimleys1883633chimleys
churls115411073churl__s
churners13316893churners
chutneys1642323chutneys
culets85518513cu_lets
cullays12347703cullays
cullers93418853cullers
cullets94015613cullets
curbers115514383curbers
curdlers11368493curdlers
curdles103814573curdle_s
cureless10319703cureless
curers84923193cur_ers
cures75645433cur_e_s
curets84922343cur_ets
curfews15294913curfews
curies84934023curie_s
curled95021653curle_d
curler85221323curle_r
curlew114010903curle_w
curls74927103curl__s
curly105321233curl_y_
cursers94317163cursers
curses85328273curse_s
curtesy1265833curtesy
curtseys1342743curtseys
curves114619283curve_s
curvets12399913curvets
curvey144111843curvey_
cuteys11569983cu_teys
cutlers94217003cutlers
cutlets94113653cutlets
darkeys15356533darkeys
doyleys14384923doyleys
duelers83412053duelers
dures65635923dur_e_s
duress74712063dur_ess
earless74316073earless
farles96025783farle_s
fleys117015603__fleys
foleys123810463_foleys
fuelers103912393fuelers
fugles104715783fugle_s
fullers103817373fullers
furies95126373furie_s
furled104717053furle_d
furler93616403furle_r
furls85322053furl__s
furzes186613693furze_s
galleys11369713galleys
garveys14124463garveys
gleys96514853__gleys
greys96614853_gr_eys
guglets9369693guglets
guiles73919283guile_s
gules64831043gu_le_s
gullets84013713gullets
gulley104213163gulley_
gumless10228273gumless
gunless8299633gunless
gurges84716863gurge_s
gurgles94312873gurgle_s
gurglets10355543gurglets
gurnets84010793gurnets
gurney10429413gurney_
gutless82610713gutless
hailers104017263hailers
hairless1157413hairless
halers94926913h_alers
hales85449843h_ale_s
hallels103310133hallels
hamlets123211403hamlets
haoles94919803haole_s
hapless123311333hapless
hardens113815023hardens
hareems12428203hareems
harems115513823har_ems
hares86255543har_e_s
harkens144112863harkens
harlots103413293harlots
harls85634503harl__s
harmers124116593harmers
harmless1337403harmless
harness102413933harness
harpers124916203harpers
harslets1137833harslets
haslets102510863haslets
hatless103813443hatless
haulers104012443haulers
hawkeys20414703hawkeys
healers104319463healers
heelers103815623heelers
heirless1146053heirless
hellers103619833hellers
henley1237483henley_
herbless1336663herbless
herders113914123herders
heres86245903her_e_s
heresy125011233her_esy
herls85226433herl__s
heroes94923823heroe_s
herpes115517323herpe_s
heydeys1732863heydeys
hickeys19508223hickeys
hillers103718733hillers
hipless12399923hipless
hirees95117293hir_ees
hirers94518063hir_ers
hires86134343hir_e_s
hirples12149643hirple_s
hirsels10128343hirsels
hirsles101510073hirsle_s
hitless103211193hitless
hockeys19509273hockeys
holes84748653h_ole_s
holey115626903h_oley_
hollers103818233hollers
homeys145012873h_omeys
honeys124016083h_oneys
honkeys17439513honkeys
hooeys125512313h_ooeys
hookeys17448953hookeys
hordes104921633horde_s
hornets104113553hornets
hornless1137363hornless
horses94729343horse_s
horsey125115403horsey_
hoseys124614003h_oseys
hourlies1138343hourlies
hourly12369623hourl_y_
howlers133312353howlers
howlets13329223howlets
hoyles12315013hoyle_s
huckles163612623huckle_s
huddlers13337633huddlers
huddles123712573huddle_s
hues75235233hu__e_s
hugely1336803hugely_
huggers124211593huggers
hulas84920883hu_l_as
hulks125715483hu_l_ks
hulky155312473hu_lky_
hulled103920013hulle_d
huller93919103hulle_r
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hu_llos
hulls84923563hu_l_ls
humblers15379803humblers
humbles143215803humble_s
hummers143813063hummers
humorless1442963humorless
humpers142713523humpers
humpless15226333humpless
humvees1534683humvees
hungers114013303hungers
hunkers143314333hunkers
hunkey164210883hunkey_
hunters103915733hunters
hurdies114015663hurdies
hurdle103712793hurdle__
hurdled12379833hurdle_d
hurdler113610003hurdle_r
hurds95219073hur__ds
hurl76029933hurl___
hurling113616413hurling
hurlings12388213hurlings
hurrahs13336773hurrahs
hurray12459913hurray_
hurriers11358893hurriers
hurries103919653hurries
hurry114917183hur_ry_
hursts97213093hur_sts
hurter93915853hurte_r
hurtle93512943hurtle__
hurtled11339593hurtle_d
hurts86922823hur__ts
hushes124718593hushe_s
huskers143510043huskers
hustlers11349203hustlers
hustles103414173hustle_s
jarveys20123413jarveys
jerseys1733243jerseys
journeys1843203journeys
juleps1535623ju_leps
jurels133710583jur_els
juries134120633jurie_s
juryless1832983juryless
kerseys1433993kerseys
leys76430183___leys
lullers73213353lullers
lurers64217493lur_ers
lures56138533lur_e_s
lurkers113910083lurkers
medleys13115333medleys
merles85322763merle_s
mooleys1236863mooleys
motleys1235683motleys
mules75034293mu_le_s
muley104819283mu_ley_
mullens93611313mullens
mullers93217303mullers
mullets93614783mullets
mulley114013453mulley_
murders103311363murders
mures75937213mur_e_s
murres85019043murre_s
murrey114312253murrey_
nucleus956573nucleus
nurled74016233nurle_d
nurls55519683nurl__s
nursers74311833nursers
nurses63919353nurse_s
nutlets74111253nutlets
oarless73913373oarless
orles55326213_orle_s
outlays102610903outlays
outlets73616363outlets
parlays123910453parlays
parles86334403parle_s
parley116718353parley_
parsleys1335083parsleys
preys105717783_pr_eys
pulers83820283pu_lers
pules74538813pu_le_s
pullers93618483pullers
pullets94015163pullets
pulley113713403pulley_
punkeys16366493punkeys
purees84721683pur_ees
purely114013613purely_
purflers13216963purflers
purfles122511843purfle_s
purgers104714003purgers
purges94421763purge_s
purled94520743purle_d
purlieus1034633purlieus
purlins93415423purlins
purls74723353purl__s
purples112712823purple_s
pursers93916093pursers
purses84826373purse_s
purvey14559573purvey_
pusley11379613pusley_
pussleys13273173pussleys
queleas1636723queleas
queys17398363qu__eys
ridleys11145783ridleys
rubles83921703ruble_s
rulers64317093ru_lers
rules55234253ru_le_s
runless72810423runless
runlets73310773runlets
smileys12336323smileys
spurreys13364593spurreys
sublets92616703sublets
sumless92611123sumless
sunless73013693sunless
surely93816453surely_
surfers103614133surfers
surgers83517483surgers
surges73924593surge_s
surly85124423surl_y_
surrey94414573surrey_
survey124111663survey_
sutlers73116973sutlers
thurls9418713thurl__s
tourneys1134013tourneys
treys85018213_tr_eys
tugless837383tugless
tules54532793tu_le_s
tulles63218893tulle_s
tureens7289873tureens
turfless1135533turfless
turkey1337763turkey_
turners73912893turners
turnkeys1542123turnkeys
turrets73010673turrets
turtlers8258203turtlers
turtles72914343turtle_s
turves94212693turve_s
unlays93810493_unlays
unless62413073_unless
uraeus638793_uraeus
ureas55826013_ur_eas
urgers73313623_urgers
urges64619913_urge_s
valleys13407483valleys
varlets10411573varlets
volleys13316643volleys
warless104015103warless
whirlers14286053whirlers
wurzels1934083wurzels
yules84521583yu_le_s

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 Limit1340273796.98319193.3
3Display Results3793790.1402707.1
 (SQL Overall)1786913797.27924548.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.