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

516 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
glanced1143923(None) 
glance94312311glance_
glancer103710071glancer
glances104113141glances
lanced93717721_lanced
balanced1356512balanced
blanched16308602blanched
blanked144011222blanked
chanced154113212chanced
clanged114212652clanged
clanked143812252clanked
danced105315252_danced
flanged123810842flanged
flanked153710642flanked
ganged94619192g_anged
glace87420152gla_ce_
glaceed1136192glaceed
glaces94218022gla_ces
gladded11357452gladded
glaired9387742glaired
glaived12375972glaived
glancers11408002glancers
gland75217712glan__d
glandes95413832glandes
glared84715192gla_red
glassed93710432glassed
glazed174711772gla_zed
gleaned9349422glean_ed
glinted9399372glinted
glunched1544262glunched
graced105217902gra_ced
granted94715102granted
laced87132642_la_ced
lance75126722_lance_
lancer84319972_lancer
lances84824102_lances
lancet84223572_lancet
landed84619242_landed
nuanced1036202nuanced
placed114318002pla_ced
planed94420912plan_ed
planked143512282planked
planned103810152planned
planted103516122planted
pranced123714042pranced
slanged94112852slanged
slanted83514742slanted
tranced104414172tranced
valanced1475462valanced
aced79540883__a_ced
acned87520663__acned
advanced1543313advanced
aland65526413alan__d
alane56135613alan_e_
alarmed1037733alarmed
alated75625143ala_ted
alined75221403alin_ed
anted66328243__anted
arced88224163__arced
balance11510263balance_
balancer1246603balancer
balances1279973balances
banded105223173_banded
baned85436353_ban_ed
banged104923723_banged
banked135021443_banked
banned94721343_banned
beaned95621473bean_ed
belaced124112153bela_ced
blabbed11357813blabbed
blacked163613373blacked
bladed104717763bla_ded
blamed116017953bla_med
blanch133410853blanc_h
blancher15338633blancher
blanches153311603blanches
bland85320453blan__d
blander103715163blander
blanker134612023blanker
blanket134313093blanket
blared95018243bla_red
blasted104213473blasted
blatted104812713blatted
blawed124713893bla_wed
blazed184314713bla_zed
blenched16358053blenched
blended114710713blended
blinded114810023blinded
blinked144010013blinked
blunged114310133blunged
blunted104210663blunted
bounced123610553bounced
braced115420603bra_ced
branched163210453branched
branded114414103branded
branned104311693branned
cancel105316683_cancel
cancer104220923_cancer
caned85838093_can_ed
canned95022063_canned
canoed94618953_canoed
canted94825783_canted
chance134617093chance_
chancel144011773chancel
chancer144215633chancer
chances145218093chances
changed144214143changed
chanted134015953chanted
clacked164113603clacked
cladded12356923cladded
clagged12749233clagged
claimed12298833claimed
clammed14369963clammed
clamped144012043clamped
clanger104113493clanger
clapped143511173clapped
clashed133614013clashed
clasped123610443clasped
classed104113653classed
clawed125115073cla_wed
clayed125013043cla_yed
cleaned103512003clean_ed
cleansed11395933cleansed
clenched16257763clenched
clinched16347383clinched
clinged113310093clinged
clinked144011643clinked
cloned94518803clon_ed
clonked14429563clonked
clunked14439573clunked
cranched163210413cranched
craned96121653cran_ed
cranked143812843cranked
dance85223133_dance_
dancer94817613_dancer
dances95120653_dances
danged94819483_danged
deaned84620453dean_ed
eland65820393elan__d
elapsed1056103elapsed
elated74725823ela_ted
enhanced1436623enhanced
enlaced102410523enla_ced
evinced1335403evinced
faced117727653_fa_ced
fancied133310603_fancied
fanged114318223_fanged
fanned104117473_fanned
farced125216533_farced
fenced124412713_fenced
fiance11310743fiance_
fiancee1238953fiancee
fiances12310673fiances
financed1435113financed
flaccid1544393flaccid
flacked173711583flacked
flagged13459633flagged
flailed1137303flailed
flaked144715653fla_ked
flamed124618973fla_med
flammed15377413flammed
flancard1443373flancard
flanes94522423flan_es
flange103411973flange_
flanger113412623flanger
flanges113413273flanges
flanken14226763flanken
flanker143911293flanker
flannel1035423flannel
flapped15328253flapped
flared105317603fla_red
flashed144112183flashed
flatbed13397983flatbed
flatted114012943flatted
flaunted1234603flaunted
flawed134712723fla_wed
flayed134414053fla_yed
fleeced13358153fleeced
flenched17267963flenched
flensed1136613flensed
flinched17316703flinched
flinted114411893flinted
flocced15365483flocced
flounced1433803flounced
flunked15398413flunked
franked153610053franked
gabbed125216893g_abbed
gabled105518453g_abled
gadded103913173g_added
gaed66031513g_a__ed
gaffed144210203g_affed
gaged85522313g_a_ged
gagged104817153g_agged
gained84617463g_ained
gaited84416923g_aited
gallanted1145893gallanted
galled84622863g_alled
gallied94115003gallied
galoped11138073galoped
gamed95126393g_a_med
gammed124216163g_ammed
gander84322763g_ander
gane55145293g_an_e_
ganef96322463g_an_ef
ganev95513863g_an_ev
ganger83721463g_anger
gannet74321853g_annet
ganoid8314443g_anoid
gaoled84814503g_aoled
gaped96123533g_a_ped
gapped124217123g_apped
garbed104815663g_arbed
garlanded1244693garlanded
garred85217403g_arred
gashed116321973g_ashed
gasped104814293g_asped
gassed85217633g_assed
gasted84821583g_asted
gated75329773g_a_ted
gauged94713473g_auged
gaumed104610323g_aumed
gawked15468763g_awked
gawped13509073g_awped
gazed165520333g_a_zed
geared85317743gea_red
gelated93615633gela_ted
ginned83813983g_inned
girned84010513girn_ed
glacier103911293glacier
glacis94012133gla_cis
glad65624013gla___d
gladden10376313gladden
gladder10398313gladder
glade75121963gla_de_
glades84820343gla_des
gladier93810993gladier
glaiket1238363glaiket
glaire74411293glaire_
glaires84010133glaires
glaive10357933glaive_
glaives11347833glaives
glancing1247063glancing
glandered1236333glandered
glanders103811503glanders
glands85314403glan_ds
glans65125833glan__s
glare65222953gla_re_
glares75518863gla_res
glarier84112203glarier
glasses84414273glasses
glaze155418163gla_ze_
glazer164212263gla_zer
glazes165315643gla_zes
glazier17409353glazier
gleamed11327933gleamed
gleaner8379773glean_er
gled65631143gl___ed
gleed75320573gl__eed
gleeked13346333gleeked
gleeted9379323gleeted
glenoid937803glenoid
gleyed11478153gl_eyed
glided94513903gl_ided
glimed105312283gl_imed
glitzed18375493glitzed
gloated93511533gloated
globed104811763gl_obed
glommed13265443glommed
gloomed11337413gloomed
glopped13347613glopped
gloried9169513gloried
glossed94410073glossed
glouted9429713glouted
gloved114811873gl_oved
glowed114913833gl_owed
glozed173711223gl_ozed
glued75118363gl__ued
glugged11396623glugged
glunch1255353glunc_h
glunches1436263glunches
glutted937243glutted
gnarled9287723gnarled
gnarred9327003gnarred
gnashed12317523gnashed
gnawed11427833gna_wed
goaded94913713goa_ded
goaled85014363goa_led
goateed9307063goateed
gonged97115913g_onged
gowaned1235763gowan_ed
gowned114410133gown_ed
grabbed13368643grabbed
grace85124543gra_ce_
graces94523493gra_ces
graded94919553gra_ded
grafted124110223grafted
grained93814273grained
grand75122693gran__d
grandad1038453grandad
grandee93115513grandee
grander93315873grander
grange83716203grange_
granger93514213granger
granges93516523granges
grantee83217133grantee
granter84117133granter
graphed1498473graphed
grasped11409063grasped
grassed93812793grassed
grated84523923gra_ted
graved114818813gra_ved
grayed115415643gra_yed
grazed174115913gra_zed
grinded104210633grinded
grinned9378553grinned
groaned9259973groan_ed
grunted9339283grunted
guarded1036153guarded
gunned83513093g_unned
hance105424153_hance_
hances115621283_hances
handed114919983_handed
hanged114222393_hanged
hanked144220603_hanked
hanted104124313_hanted
inlaced10239873inla_ced
islanded1035513islanded
jaunced17335473jaunced
jeaned143813463jean_ed
jounced17337613jounced
lace66848473_la_ce_
lacer75833753_la_cer
laces76141763_la_ces
lacey105820913_la_cey
lacked135324653_lacked
laded74232613_la_ded
ladled85013483_ladled
lagged95520133_lagged
laired75216813_laired
laked105731123_la_ked
lalled74218753_lalled
lambed115614783_lambed
lamed85235293_la_med
lammed113915623_lammed
lamped114017543_lamped
lanated8313203_lanated
lancers93616643_lancers
lanceted1137073_lanceted
lancets93411163_lancets
land56337303_lan__d
lander74028483_lander
lane45153323_lan_e_
lanes54946793_lan_es
lanker104123003_lanker
lanner64920603_lanner
lapped114320033_lapped
lapsed94712583_lapsed
larded84319093_larded
larked114519473_larked
lased65132343_la_sed
lashed105625213_lashed
lasted74323603_lasted
latched133914063_latched
lated65240673_la_ted
lathed104718453_lathed
lauded83812153_lauded
launce8469183_launce_
launces9329003_launces
launched1475403_launched
laved95028593_la_ved
lawed96028323_la_wed
layed95127383_la_yed
lazed154925843_la_zed
lazied164610653_lazied
leaned73422543lean_ed
lensed74015473_lensed
lined64934643_lin_ed
linked114518213_linked
linted74021823_linted
loaned73816293loan_ed
longed87121373_longed
lunched133911823_lunched
lunged85418273_lunged
lunted74517523_lunted
lynched16376753_lynched
maced108528693_ma_ced
maned86634093_man_ed
manned94418643_manned
menaced122710093menaced
minced114114913_minced
moaned94514173moan_ed
nance74721843_nance_
nances83618643_nances
nuance859043nuance_
nuances938523nuances
paced106931683_pa_ced
palaced124110773palaced
paned85437183_pan_ed
panged104722333_panged
panned94123433_panned
panted95024823_panted
peaced115818913pea_ced
penanced1338163penanced
place94824613pla_ce_
placer105117743pla_cer
places104323703pla_ces
placet103923673pla_cet
placid114012543pla_cid
plagued11307473plagued
plaice10311553plaice_
plaices11411143plaices
plaided11409643plaided
plained103812233plained
plaited103713893plaited
planch133711443planc_h
planche14299753planche
planches153111863planches
planchet152511963planchet
plane74929143plan_e_
planer84122653plan_er
planes85028083plan_es
planet84228353plan_et
planner93511623planner
planter94017803planter
plashed133712643plashed
plated95225773pla_ted
platted103614263platted
played124815033pla_yed
plinked143910893plinked
plonked14348103plonked
plunged11439523plunged
plunked14429593plunked
ponced114314813_ponced
pounced123510623pounced
prance104318573prance_
prancer113613383prancer
prances113618773prances
pranged114512553pranged
pranked143712093pranked
quanted1738963quanted
raced87635313_ra_ced
rance75028513_rance_
rances84625443_rances
ranched133113603_ranched
rancid9513863_rancid
ranged84824313_ranged
ranked114620743_ranked
ranted74324703_ranted
relaced103517213rela_ced
relanded102410463relanded
romanced1337253romanced
sanded84920613_sanded
saned65636273_san_ed
sauced93913303_sauced
scanned104110893scanned
scanted104114393scanted
sconced12359173sconced
seance83716683seance_
seances93015343seances
shanked153212123shanked
silenced1136273silenced
skanked11338103skanked
slabbed12409503slabbed
slacked143815453slacked
slagged104312773slagged
slaked114318273sla_ked
slammed123511103slammed
slander84015443slander
slapped123511843slapped
slashed114114853slashed
slated75028313sla_ted
slatted84015183slatted
slaved104017043sla_ved
slayed104716223sla_yed
sliced94416313sl_iced
slinked123011383slinked
sluiced1046053sluiced
solaced102911063sola_ced
spaced114517253spa_ced
spancel1147363spancel
spanked143111733spanked
spanned104111223spanned
stance84316913stance_
stances93715963stances
stanched14208903stanched
staned74824643stan_ed
stanged94113843stanged
swanked15359543swanked
swanned11358173swanned
synced12266963_synced
talced93811003_talced
tanged84622493_tanged
tanked113919293_tanked
tanned75219953_tanned
thanked15469153thanked
traced94821583tra_ced
trance84718763trance_
trances93919643trances
twanged12387273twanged
unlaced102913733unla_ced
usance858013usance_
usances967373usances
valance1269253valance_
valances1398763valances
vaned94622423_van_ed
vanned104614483_vanned
waned95831783_wan_ed
wanked144517153_wanked
wanned104318013_wanned
wanted104319723_wanted
weaned103816153wean_ed
whanged15447613whanged
winced124415343_winced
yanked144312243_yanked
yeaned103813903yean_ed
zinced18419413_zinced

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 Limit1340275167.37318178.1
3Display Results5165160.1862774.2
 (SQL Overall)1786915167.71523161.5
 
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.