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

505 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
dallied9371361(None) 
allied74217151_allied
dallier84215371dallier
dallies84023191dallies
dollied93811141dollied
gallied94115001gallied
rallied83514081rallied
sallied83316951sallied
tallied83314751tallied
allies63827672_allies
balled94926892ball_ed
ballies93725742ballies
bellied104314072bellied
bullied104514812bullied
called94126732call_ed
collied103316672collied
cullied104012352cullied
dailies84219262dailies
daisied93410012daisied
dalles74222062dall_es
dalliers93610612dalliers
dellies83622212dellies
dialled9510132diall_ed
dilled84122222dill_ed
dillies84122162dillies
dolled83518072doll_ed
dollies83620982dollies
dulled84719422dull_ed
galled84622862gall_ed
gallies84122712gallies
gillied95512312gillied
gullied93812062gullied
halloed113314912halloed
jellied15419222jellied
jollied15349272jollied
lalled74218752lall_ed
malled94626112mall_ed
palled94625162pall_ed
pallid93915282palli_d
pallier94417162pallier
palsied102911302palsied
rallier73816272rallier
rallies73823342rallies
sallier73320422sallier
sallies73227812sallies
sullied83714482sullied
tallier72817212tallier
tallies73624602tallies
unallied938392unallied
walled104021292wall_ed
wallie93216802wallie_
wallies103320742wallies
willied114611562willied
abled86926833_abl_ed
addled94112523addl_ed
aeried74221863_aeried
ailed66240283_ail_ed
alated75625143_alated
alcid85817973_alci_d
algid75415583_algi_d
alibied1038143_alibied
alien56425583_a_lien
alined75221403_alined
aliped95414283_aliped
alkie95520033_alkie_
alkies104518093_alkies
allayed11138063_allayed
allee54932123_all_ee
allees64521483_allees
alleged9389323_alleged
alley85721673_all_ey
allium8311243_allium
allod64418383_all_od
allowed111610083_allowed
alloyed11158033_alloyed
allseed835953_allseed
allude73910903_allude
alluded9327093_alluded
allured8299173_allured
applied1247483applied
ariled75620323_ariled
axled135315813_axl_ed
babied114913513ba_bied
bailed94726653bail_ed
bailie83818363bailie_
bailies94120203bailies
balded105417513ba_lded
baldies105317703baldies
baled85436443ba_l_ed
balked135219413ba_lked
balkier134111983balkier
ballad94315323ball_ad
ballade104012563ballade
baller83825203ball_er
ballet84733973ball_et
balling104424763balling
balloted1189043balloted
ballsier1036523ballsier
balmier113811513balmier
bandied114414303bandied
baulked14465623baulked
bawled124415693bawl_ed
belied95022163_belied
belled94626183bell_ed
bellies94023723bellies
billed94224903bill_ed
billie85019173billie_
billies93923503billies
bolled94722653boll_ed
bollixed1834483bollixed
bulled94626493bull_ed
bullier94116433bullier
bullies94121893bullies
cabled114819873cabl_ed
caddied123710563caddied
calcined1338743calcined
calked134617403ca_lked
callee84327293call_ee
callees94117783callees
caller85125483call_er
callet84536763call_et
calling103826773calling
callipee1237733callipee
calliper1247513calliper
callused1135853callused
calmed114816383ca_lmed
calqued19306523calqued
calved125215453ca_lved
candied113816023candied
caried94528693ca_ried
carried103717153carried
caulked14486673caulked
caviled1348723caviled
celled94420323cell_ed
challie124012853challie_
challies133915643challies
collide103214793collide
collided12309803collided
collie83621993collie_
collier93618153collier
collies94326583collies
culled94022473cull_ed
cullies94419963cullies
dabbed124416143da_bbed
dabbled133712073dabbled
daddies103414943daddies
daddled113810743daddled
dadoed9449903da_doed
daffed14429493da_ffed
daffier1457833daffier
daggled11329463daggled
dahlia1035773dahli_a
dahlias1135723dahlias
dairies84217733dairies
daisies84217093daisies
dale55643983da_l_e_
daledh1133743da_l_edh
dales66439743da_l_es
dally95324743dall__y
dallying13368493dallying
damaged1257453damaged
dammed124214793da_mmed
damned104212913da_mned
damped124315583da_mped
danced105315253da_nced
dandier93714573dandier
dandies94121443dandies
dandled103313543dandled
danged94819483da_nged
dangled104013153dangled
danglier1056753danglier
dapped124516763da_pped
dappled1336393dappled
darbies104216983darbies
dared75935013da__red
darked123919633da_rked
darkie113714013darkie_
darkies124015753darkies
darkled13378723darkled
darklier1335013darklier
darling93418363darling
darned85018483da_rned
darted84620923da_rted
dartled9409853dartled
dashed115920563da_shed
dashier114311183dashier
dassie74615573dassie_
dassies84418663dassies
dated75530993da__ted
datelined1194713datelined
daubed104611783da_ubed
daubier1037103daubier
daunted93810193daunted
dauted84114933da_uted
dautie72914703dautie_
dauties83315763dauties
davened124610073davened
davies105020513da_vies
dawdled13376723dawdled
dawed106222813da__wed
dawned113912093da_wned
dawted11489683da_wted
dawtie103011093dawtie_
dawties113312703dawties
daybed13438673da_ybed
dayflies1534463dayflies
daylilies1343123daylilies
daylily1434983daylily
daylit10512493dayli_t
dayside1236173dayside
dazed165919363da__zed
dazzled1735033dazzled
deadlier1036863deadlier
deadlined12125323deadlined
dealated103213603dealated
declined123910883declined
decried112612853decried
defied115016383d_efied
defiled124013103defiled
deified123112413deified
delated93722873delated
delayed123310763delayed
deled75326543d_el_ed
deleted93314913deleted
delimed11310723delimed
deluded10158763deluded
deluged10167413deluged
delved114112753d_elved
denied84318633d_enied
deviled124112183deviled
dialed84716453dial_ed
diallel845683diall_el
dialler848813diall_er
dialling10310783dialling
diallist949553diallist
dialoged1146693dialoged
dialysed1344413dialysed
dialyzed2243733dialyzed
died66137853d___ied
dilated93115823dilated
diluted9248933diluted
dirled84514903dirl_ed
dirtied93210853dirtied
disliked14288553disliked
divvied1544813divvied
dizzied17236133dizzied
doiled84817293doil_ed
doilies84017363doilies
doled75430913d_ol_ed
dolling93817373dolling
dollish11610093dollish
dolloped1234983dolloped
doolie73916833doolie_
doolies83920713doolies
doylies114512573doylies
drawled12368343drawl_ed
drawlier12225253drawlier
dried75321383d__ried
drilled94711673drilled
drolled93810223drolled
dualized1937403dualized
dueled84813663duel_ed
duelled9359753duelled
dullard936603dullard
duller74017703dull_er
dulling93418273dulling
dullish1148743dullish
dummied13346723dummied
dwelled12337593dwelled
eagled82914043eagl_ed
earlier72612743earlier
fabled124216383fabl_ed
failed105421603fail_ed
fallen93813373fall_en
faller94621233fall_er
falling113621583falling
fallowed15127753fallowed
falsie93513853falsie_
falsies103515013falsies
fancied133310603fancied
faulted11227723faulted
felled103720303fell_ed
fellies104119743fellies
filled104922263fill_ed
fillies103420253fillies
filliped1435223filliped
flailed1137303flailed
flied96519433__flied
follies103618943follies
fulled103820653full_ed
gabled105518453gabl_ed
galilee8312213galilee
gallein8299043gallein
galleried1146923galleried
gallet73630853gall_et
galleted1038213galleted
galley104215453gall_ey
galliard10125753galliard
gallic9411643galli_c
gallica1047463gallica
galling93921963galling
galliot82214133galliot
gallium1037943gallium
galloped12107143galloped
gallused1034193gallused
galoped11138073galoped
gaoled84814503gaol_ed
gelled84718893gell_ed
gilled84521633gill_ed
gillie74816943gillie_
gillies84120963gillies
gulled84521373gull_ed
gullies84717313gullies
hailed104122743hail_ed
haled95335823ha_l_ed
halid94424983ha_li_d
halide103417993ha_lide
hallel93514093hall_el
halliard12125963halliard
halloaed121510153halloaed
halloes104021523halloes
hallooed12168773hallooed
hallowed15179493hallowed
haloed104717603ha_loed
haloid104317763haloi_d
halted105019603ha_lted
halved134813903ha_lved
harried113815533harried
hauled104415213haul_ed
haulier1059943haulier
helled104024703hell_ed
helloed113512423helloed
hilled104022223hill_ed
hillier103413963hillier
hilloed113211293hilloed
hollaed11359853hollaed
hollies103420813hollies
holloed113812753holloed
hulled103920013hull_ed
hulloed11369793hulloed
implied1238623implied
jailed144917423jail_ed
jelled144916063jell_ed
jellies143816533jellies
jollier142911003jollier
jollies143516273jollies
kellies113516853kellies
killed113918773kill_ed
killie104114893killie_
killies113318113killies
ladled85013483ladl_ed
lalland83810183lalland
lalling83519623lalling
lazied164610653la_zied
lied55838093___lied
lilied73913213_lilied
lolled74315823loll_ed
lollies73116923lollies
lulled74516443lull_ed
macled116718113macl_ed
mailed95326753mail_ed
malfed12369763ma_lfed
mallard10310273mallard
mallee84525593mall_ee
mallees93315973mallees
mallei84414633mall_ei
mallet84433053mall_et
malling103623663malling
malmier113611953malmier
malted94819863ma_lted
maltier93015483maltier
manlier92414023manlier
marled95523163marl_ed
marlier92614773marlier
married104715303married
mauled94817823maul_ed
medalled1246893medall_ed
melled95023023mell_ed
milled94326173mill_ed
millier93716703millier
milliped1337383milliped
misallied1246543misallied
mollie83517103mollie_
mollies93420233mollies
mulled94721553mull_ed
nailed74021493nail_ed
naled65525053na_l_ed
nellie63614813nellie_
nellies73418723nellies
nilled73919453nill_ed
nulled74318273null_ed
palaced124110773palaced
paled85538723pa_l_ed
palier85023563pa_lier
pallet84232653pall_et
palleted1139873palleted
pallia83015593palli_a
pallial92911253pallial
palliated1238493palliated
palliest102814633palliest
palling104024483palling
pallium1149013pallium
palmed114314643pa_lmed
palmier113312173palmier
palped114513643pa_lped
palsies94420273palsies
pandied113913443pandied
parled94626293parl_ed
parried103615723parried
parslied1137823parslied
partied103516553partied
pedalled1246933pedall_ed
pilled94222753pill_ed
plied85118593__plied
polled94022003poll_ed
pulled94322193pull_ed
railed74727543rail_ed
ralliers84010833ralliers
ralline73518413ralline
rallye95110163rallye_
rallyes10348553rallyes
ralphed1334363ralphed
relied74926233_relied
replied103914453replied
retallied1046783retallied
rilled74525653rill_ed
rolled74220243roll_ed
sailed74327763sail_ed
salaried9311023salaried
salified12310363salified
sallet63734543sall_et
salliers83613343salliers
sallowed12149033sallowed
salpid9510883salpi_d
salted74121203sa_lted
saltie63422433saltie_
saltier74318633saltier
salties73725773salties
saluted84511713saluted
salved103916423sa_lved
salvoed11307063salvoed
savvied1433803savvied
sillier74017593sillier
sillies73425083sillies
spalled103113133spall_ed
stalled83515683stall_ed
sullies74122233sullies
tabbied12297793tabbied
tabled94020043tabl_ed
tailed74424663tail_ed
talced93811003ta_lced
talcked1446343talcked
taliped1078203taliped
talked114015403ta_lked
talkie103914443talkie_
talkier114011843talkier
talkies113415733talkies
tallaged10257923tallaged
taller63721963tall_er
talliers83711373talliers
tallis63319963talli_s
tallises82713263tallises
tallish103313583tallish
tallit63422733talli_t
tallith102913063tallith
tallits73215993tallits
tallowed12157713tallowed
taloned8310223taloned
tarried83914133tarried
taxied14509373ta_xied
tellies73820503tellies
tilled74722953till_ed
tolled73819033toll_ed
trollied935893trollied
vailed104619293vail_ed
valeted1139013valeted
valid94618393va_li_d
valley124311603vall_ey
valleyed1534013valleyed
valued104011153va_lued
valved136711043va_lved
varied104817863va_ried
vaulted11307193vaulted
vialled1156843viall_ed
waddied13358563waddied
wailed104823593wail_ed
waled94330993wa_l_ed
walies95324523wa_lies
walked145313783wa_lked
wallet93327093wall_et
walleyed1534153walleyed
walling113520973walling
walloped14146833walloped
wallowed15148163wallowed
waltzed2033493waltzed
wauled104713963waul_ed
wawled133811703wawl_ed
welled103820213well_ed
wellie92814913wellie_
wellies103719073wellies
willed104722453will_ed
willie94116453willie_
willies103920153willies
yawled13459983yawl_ed
yelled104116253yell_ed

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.406440125.6
2DLD Change Limit1340275056.06322105.7
3Display Results5055050.1862715.1
 (SQL Overall)1786915056.65526850.6
 
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.