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

405 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
hurdler11361000(None) 
curdler103511561curdler
huddler12379421huddler
hurdle103712791hurdle_
hurdled12379831hurdled
hurdlers12337491hurdlers
hurdles113613371hurdles
hurler94717221hur_ler
bundler104011722bundler
burbler114412422burbler
burler84723832bur_ler
cuddler113810742cuddler
curdier103312612curdier
curdle95514312curdle_
curdled113910662curdled
curdlers11368492curdlers
curdles103814572curdles
curler85221322cur_ler
furler93616402fur_ler
girdler9227312girdler
handler113516162handler
harder105022402hard_er
hardier114721542hardier
herder104516462herd_er
huddle113712992huddle_
huddled13349782huddled
huddlers13337632huddlers
huddles123712572huddles
huller93919102hu_ller
humbler143411942humbler
hurdies114015662hurdies
hurled104617452hur_led
hurlers103714322hur_lers
hurley125012522hur_ley
hurrier103412932hurrier
hurter93915852hur_ter
hurtle93512942hurtle_
hurtled11339592hurtled
hurtles103913752hurtles
hustler103410752hustler
muddler113411622muddler
murder93613782murd_er
puddler112910752puddler
purfler12248732purfler
purpler11289262purpler
turtler72610322turtler
aulder7511453auld_er
birder94915493bird_er
birler85715083bir_ler
boodler103312003boodler
border94419973bord_er
bridler103811073bridler
bubbler103611783bubbler
buckler154112033buckler
budder104314813bu_dder
buddle104313083buddle_
buddles113913073buddles
budger104617703bu_dger
bugler94717723bu_gler
builder1037573builder
bumbler134013233bumbler
bundle94315573bundle_
bundled114011303bundled
bundlers11399183bundlers
bundles103515773bundles
bungler104611483bungler
burble104617703burble_
burbled124312673burbled
burblers12399263burblers
burbles114916803burbles
burblier1255603burblier
burden9412473burd_en
burdener1136133burdener
burdie93615023burdie_
burdies104117563burdies
burger94020793bur_ger
burgher1337003burgher
burglar1065533burglar
burgle94815863burgle_
burgled115511423burgled
burgles105615963burgles
burier84324653bur_ier
burker125221173bur_ker
burled94825383bur_led
burlers94120273bur_lers
burley114715753bur_ley
burlier93514413burlier
burner83819203bur_ner
burrer83718473bur_rer
burrier93613543burrier
burster9310293burster
bustler94012563bustler
butler84220033bu_tler
candler103516593candler
carder94524183card_er
caroler93816753caroler
chandler14358373chandler
chortler13336843chortler
chuckler1935553chuckler
chudder14245943chu_dder
churner12298343chur_ner
circler1136423circler
coddler113710823coddler
corder94322873cord_er
coruler9311713coruler
cradler102910503cradler
cruder95612383crud_er
crueler939023crueler
cruller968753cruller
cuddle104414533cuddle_
cuddled124110763cuddled
cuddlers12388383cuddlers
cuddles114014093cuddles
cuddlier1234013cuddlier
culler84322253cu_ller
cupeler1177483cupeler
curber104517053cur_ber
curded104217163curd_ed
curer75030753cur__er
curled95021653cur_led
curlers94218063cur_lers
curlew114010903cur_lew
curlier93314183curlier
currier93316693currier
curser84721473cur_ser
curter85320073cur_ter
curule83614123curule_
curvier123110663curvier
cutler84718033cu_tler
dandler94414273dandler
dawdler12356793dawdler
diddler103511513diddler
doodler93310153doodler
drudger10328323drudger
dueler74213683du_eler
dueller8329833dueller
duller74017703du_ller
fiddler12309953fiddler
fondler11348883fondler
fuddle113312103fuddle_
fuddled13309393fuddled
fuddles123611933fuddles
fueler94313933fu_eler
fueller10279963fueller
fuller94220383fu_ller
fumbler143610813fumbler
funder104016083fund_er
furled104717053fur_led
furlers104214223fur_lers
furrier103513643furrier
further1337003further
furzier19318093furzier
garbler104012563garbler
gargler93710263gargler
girder84312063gird_er
girdle82110463girdle_
girdled10217453girdled
girdlers10195403girdlers
girdles92210003girdles
grudger10368313grudger
grueler837023grueler
guarder936463guard_er
guider84313523guid_er
guilder945913guilder
gurgle83912473gurgle_
gurgled10399123gurgled
gurgles94312873gurgles
gurglet94412033gurglet
guttler8369163guttler
guzzler16286563guzzler
hackler163512353hackler
haggler12328933haggler
hailer94720343h_ailer
haler85033523h__aler
hander104526433hand_er
handier113817443handier
handle104219293handle_
handled124114533handled
handlers124014143handlers
handles114020653handles
harden105718533hard_en
hardener1238883hardener
hardies114923233hardies
hardly135112833hardl_y
hardset113415833hardset
harmer114719553har_mer
harper115018403har_per
harrier104417753harrier
harsher13310363harsher
harslet10315653harslet
hauler95015123h_auler
header104422543head_er
headier113212953headier
healer94221803h_ealer
heckler16278573heckler
heddle114211163heddle_
heddles123311623heddles
heder95623633h_ed_er
hedger114912633h_edger
heeder104216043heed_er
heeler93917313h_eeler
heller93322513h_eller
herbier1239593herbier
herded114215643herd_ed
herders113914123herd_ers
herdmen13238453herdmen
hider95024083h_id_er
higgler12369803higgler
hiller94421633h_iller
hinder104120063hind_er
hirer85423123hir__er
hirple11158973hirple_
hirpled13157133hirpled
hirples12149643hirples
hirsle9159573hirsle_
hirsled11118113hirsled
hirsles101510073hirsles
hoarder11329233hoard_er
hobbler143710403hobbler
holder104619653hold_er
holler93520613h_oller
hondle103914523hondle_
hondled123510653hondled
hondles113614523hondles
hoodier113812973hoodier
horde94623053hord_e_
horded115420483hord_ed
hordes104921633hord_es
hornier103012453hornier
horsier103013243horsier
hostler103411023hostler
hounder113412233hound_er
howler123514313h_owler
huckle153913073huckle_
huckles163612623huckles
huffier1637493huffier
huger94914873hu__ger
hugger114713123hu_gger
hulkier14328973hulkier
hulled103920013hu_lled
hullers103616263hu_llers
humaner12257663humaner
humble133615053humble_
humbled153711813humbled
humblers15379803humblers
humbles143215803humbles
hummer133615273hu_mmer
humper134115883hu_mper
humpier143110723humpier
hundred1237143hundred
hunger104015203hu_nger
hunker133917673hu_nker
hunkier144512143hunkier
hunter94817773hu_nter
hurdling13288013hurdling
hurds95219073hurd__s
hurl76029933hur_l__
hurleys13407333hur_leys
hurlies103315333hurlies
hurls86522713hur_l_s
hurly115819293hur_l_y
hurried113511043hurried
hurriers11358893hurriers
hurries103919653hurries
hurters103413633hur_ters
hurtless11307783hurtless
husker134212703hu_sker
huskier14369753huskier
hustle93113993hustle_
hustled113210133hustled
hustlers11349203hustlers
hustles103414173hustles
idler65015663__idler
judder15439423ju_dder
judger154411443ju_dger
juggler16418873juggler
jumbler183910273jumbler
kindler12309983kindler
kruller1145153kruller
ladler74314933_ladler
landler84113203landler
larder73720973lard_er
lardier83518343lardier
lordlier935353lordlier
luller63415483lu_ller
lurcher12338133lurcher
lurer54625313lur__er
lurker103613293lur_ker
marbler113511673marbler
meddler11319953meddler
middler112712273middler
mudder104413493mu_dder
muddier114110013muddier
muddle103414633muddle_
muddled124111583muddled
muddlers12428803muddlers
muddles112914353muddles
muffler15398343muffler
muller83820353mu_ller
mumbler133510913mumbler
muraled10410823muraled
murderer1145263murderer
murders103311363murd_ers
murker123715243mur_ker
murkier133110263murkier
murther1237953murther
muzzler17257943muzzler
needler8388893needler
nerdier83110353nerdier
nuder66416833nu_d_er
nudger85111633nu_dger
nurled74016233nur_led
nurser64314503nur_ser
nuzzler15296493nuzzler
order65019363_ord_er
outdoer849263outdoer
paddler113711553paddler
pardner10239473pardner
peddler113210493peddler
pedler93614613_pedler
piddler112911523piddler
puddle103914153puddle_
puddled123011193puddled
puddlers12298683puddlers
puddles113613823puddles
puddlier1234213puddlier
puler74826623pu__ler
puller83820813pu_ller
purer75127903pur__er
purfle112511183purfle_
purfled13248723purfled
purflers13216963purflers
purfles122511843purfles
purger94717233pur_ger
purled94520743pur_led
purple102712673purple_
purpled12299763purpled
purples112712823purples
purser85020473pur_ser
pursier94012753pursier
pursuer9338893pursuer
purtier93214093purtier
puzzler17276963puzzler
queller16289293queller
riddler93411263riddler
rudder83812803ru_dder
ruddier9338523ruddier
ruddle83414203ruddle_
ruddled103010873ruddled
ruddles92813873ruddles
ruder65320543ru_d_er
ruffler13369723ruffler
ruler54923343__ruler
rumbler113514113rumbler
rundle73214233rundle_
rundles83214713rundles
rundlet83114153rundlet
rustler73512343rustler
saddler93811963saddler
shudder12297323shu_dder
shuffler17306793shuffler
shuttler1164893shuttler
sidler74716963_sidler
sturdier9216953sturdier
subduer10107033subduer
subtler92910843subtler
suckler133413093suckler
sudser73511283su_dser
sunder74019823sund_er
suppler1148433suppler
surer54833093sur__er
surfer93515883sur_fer
surfier102613543surfier
surger74320093sur_ger
surlier72915443surlier
sutler63718393su_tler
tardier859719993tardier
thunder1136963thund_er
thurifer1443273thurifer
tiddler93110003tiddler
toddler9379043toddler
trudger9338723trudger
trundler9256143trundler
tumbler113412823tumbler
tummler11266613tummler
turfier10249793turfier
turner63914613tur_ner
turtle63213573turtle_
turtled8309683turtled
turtlers8258203turtlers
turtles72914343turtles
udder76314283_u_dder
under64624213_und_er
undoer73113043_undoer
ureter6313203_ureter
urger64116473_ur_ger
waddler124010793waddler
warbler123211463warbler
warder104020273ward_er
warsler10289893warsler
wheedler1543543wheedler
whirler13307603whir_ler
wordier112511203wordier
yarder103813973yard_er
yodler10389943_yodler

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.1531167915.0
2DLD Change Limit1340274057.33018284.7
3Display Results4054050.1562596.2
 (SQL Overall)1786914057.63923391.9
 
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.