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

547 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
glance9431231(None) 
glace87420151gla_ce
glanced11439231glanced
glancer103710071glancer
glances104113141glances
lance75126721_lance
alane56135612alan_e
balance11510262balance
blanch133410852blanch
chance134617092chance
dance85223132_dance
fiance11310742fiance
flange103411972flange
gane55145302g_an_e
glaces94218022gla_ces
glade75121962gla_de
glaire74411292glaire
glaive10357932glaive
glancers11408002glancers
gland75217712glan_d
glandes95413832glandes
glands85314402glands
glans65125832glan_s
glare65222952gla_re
glaze155418162gla_ze
glunch1255352glunch
grace85124542gra_ce
grange83716202grange
hance105424152_hance
lace66848472_la_ce
lanced93717722_lanced
lancer84319972_lancer
lances84824102_lances
lancet84223572_lancet
lane45153332_lan_e
launce8469182_launce
nance74721842_nance
nuance859042nuance
place94824612pla_ce
plaice10311552plaice
planch133711442planch
planche14299752planche
plane74929142plan_e
prance104318572prance
rance75028512_rance
seance83716692seance
stance84316912stance
trance84718762trance
usance858012usance
valance1269252valance
ace59656833__a_ce
acne66625873__acne
advance1346043advance
aglare7312423agla_re
alack114820063ala_ck
alae45643753ala__e
alan46844083alan__
aland65526413alan_d
alands75418373alands
alang66023513alan_g
alanin6317273alanin
alanine7316863alanine
alans55636173alan_s
alant55742293alan_t
alants67722023alants
alanyl955483alanyl
alate55340323ala_te
aline57243153alin_e
alkane104313323alkan_e
alliance1097263alliance
almuce10348213almuce
alone55732963alon_e
ananke1038283ananke
ane37866953__an_e
anlace82513923anla_ce
ante46538903__ante
apace94718383apa_ce
askance1345923askance
balanced1356513balanced
balancer1246603balancer
balances1279973balances
banco94019393_banco
bane65250433_ban_e
beanie83618593beanie
black134719073bla_ck
blade85923333bla_de
blae66134643bla__e
blame95625493bla_me
blanched16308603blanched
blancher15338633blancher
blanches153311603blanches
bland85320453blan_d
blander103715163blander
blank115418553blan_k
blanked144011223blanked
blanker134612023blanker
blanket134313093blanket
blanks124112893blanks
blare75826233bla_re
blase75524233bla_se
blate75933783bla_te
blaze165520833bla_ze
blench133710453blench
blende95413443blende
blonde94813293blonde
blunge94311483blunge
bounce104014833bounce
brace95629273bra_ce
branch134014773branch
cancel105316683_cancel
cancer104220923_cancer
cane66653123_can_e
canoe75627253_canoe
chanced154113213chanced
chancel144011773chancel
chancer144215633chancer
chances145218093chances
chancre14348783chancre
chancy164010863chancy
change124116753change
clach124617823cla_ch
clack134720173cla_ck
clade85821013cla_de
clan65633923clan__
clang86019313clan_g
clanged114212653clanged
clanger104113493clanger
clangs95113613clangs
clank114719523clan_k
clanked143812253clanked
clanks124615183clanks
clanky15469073clanky
clans75031013clan_s
claque17338563claque
clarence1246453clarence
clause84311503clause
clave105420153cla_ve
cleanse9358723cleanse
clench133910053clench
clinch133910353clinch
cline76428533clin_e
clone75728163clon_e
cranch133613533cranch
crane75331603cran_e
dace76934923_da_ce
danced105315253_danced
dancer94817613_dancer
dances95120653_dances
dunce86319263_dunce
durance1059113durance
elan46734243elan__
eland65820393elan_d
elands74914773elands
elans55527753elan_s
elapse857523elapse
elate55335883ela_te
elegance1146373elegance
enhance1239693enhance
enlace82213233enla_ce
evince1137763evince
face96140123_fa_ce
fancy134615483_fancy
fane75343573_fan_e
farce104925323_farce
fence105319913_fence
fiancee1238953fiancee
fiances12310673fiances
finance1238573finance
flack144519413fla_ck
flake125119973fla_ke
flambe13489153flambe
flame105124443fla_me
flan76134183flan__
flanes94522423flanes
flanged123810843flanged
flanger113412623flanger
flanges113413273flanges
flank124618093flan_k
flanked153710643flanked
flanken14226763flanken
flanker143911293flanker
flanks133913403flanks
flannel1035423flannel
flans85327973flan_s
flare84823633fla_re
fleece11369903fleece
flench144010813flench
flense938903flense
flinch144010103flinch
flounce1235413flounce
franc104615413franc_
francs114112193francs
gable85325523g_able
gadje1457743g_adje
gae46457703g_a__e
gaffe124111653g_affe
gage65936103g_a_ge
galanga936013galanga
gale56347323g_a_le
galeae74717453galeae
galere73716673galere
galore73514853galore
gambe106219213g_ambe
game76644323g_a_me
gan48060133g_an__
ganache1346203g_anache
gander84322763g_ander
ganef96322463g_anef
ganev95513863g_anev
gang66031973g_an_g
ganged94619193g_anged
ganger83721463g_anger
gangs76222573g_angs
gangue81310573g_angue
ganja131410003g_anja
gannet74321853g_annet
ganof95420363g_anof
gape75134513g_a_pe
gate55746573g_a_te
gauche1238553g_auche
gauge76117903g_auge
gauze155712973g_auze
gave84634053g_a_ve
gaze145032413g_a_ze
gelable101710733gelable
gelant72821673gelan_t
gelants82611443gelants
gelate73421253gela_te
gene56237223g_en_e
genie66124923g_enie
genre66016803g_enre
giant65430593gian_t
giants74713503giants
glaceed1136193glaceed
glacier103911293glacier
glacis94012133glacis
glad65624013gla__d
gladded11357453gladded
gladden10376313gladden
gladder10398313gladder
glades84820343glades
gladier93810993gladier
gladly11497933gladly
glads75620613gla_ds
glady105413943gla_dy
glaiket1238363glaiket
glair65313553gla_ir
glaired9387743glaired
glaires84010133glaires
glairs75211333glairs
glairy10448273glairy
glaived12375973glaived
glaives11347833glaives
glam76529343gla__m
glamor958183glamor
glams85822933gla_ms
glancing1247063glancing
glanders103811503glanders
glandule1043853glandule
glared84715193glared
glares75518863glares
glarier84112203glarier
glary96018543gla_ry
glass65518133gla_ss
glassed93710433glassed
glasses84414273glasses
glassie8329493glassie
glassy10527753glassy
glazed174711773glazed
glazer164212263glazer
glazes165315643glazes
glazier17409353glazier
glazy187410983gla_zy
glean65818203glean__
gleaned9349423gleaned
gleaner8379773gleaner
gleans75014743glean_s
glebae9407613glebae
glebe85016443gl_ebe
glede75517833gl_ede
glee55239063gl__ee
glen56027203glen__
glens66519853glen_s
glide74521593gl_ide
glime85620193gl_ime
glint66830183glin_t
glinted9399373glinted
glints75714213glints
glinty106910693glinty
glitch12286353glitch
globe84917013gl_obe
glove94516293gl_ove
gloze154815983gl_oze
glue55628493gl__ue
glume85120463gl_ume
glunched1544263glunched
glunches1436263glunches
glute66020903gl_ute
goalie7413163goalie
goanna736653goanna
goatee73219533goatee
gone55639043g_on_e
goonie73615563goonie
graced105217903gra_ced
graces94523493gra_ces
grade75126093gra_de
gramme114210333gramme
gran56335013gran__
grana65722093gran_a
grand75122693gran_d
grandee93115513grandee
grander93315873grander
grands84218243grands
granger93514213granger
granges93516523granges
granite82017083granite
grannie8310353grannie
granny104311163granny
grans64832543gran_s
grant64840023gran_t
granted94715103granted
grantee83217133grantee
granter84117133granter
grants73722473grants
granule839473granule
granum9310913granum
grape84824663gra_pe
grate64932883gra_te
grave94624873gra_ve
graze155820053gra_ze
grinch1238483grinch
grunge8359583grunge
guaco85012163gua_co
guan55325583guan__
guanaco1064583guanaco
guanase836213guanase
guanay1037913guanay
guanin7610803guanin
guanine8810543guanine
guano69213983guan_o
guanos73811993guanos
guans64419443guan_s
guidance1244983guidance
gwine95513663gwin_e
hances115621283_hances
hanse85722793_hanse
hence104920043_hence
inane52820343inan_e
inlace82513043inla_ce
jane115031483_jan_e
jaunce15367433jaunce
jounce153310733jounce
joyance1944773joyance
kane85133973_kan_e
klatch15445933klatch
lac510155823_la_c_
laced87132643_la_ced
lacer75833753_la_cer
laces76141763_la_ces
lacey105820913_la_cey
lack105837683_la_ck
lacs66942483_la_cs
lacy95829633_la_cy
lade56345983_la_de
ladle66320443_ladle
laic65931563_laic_
laich105920713_laich
laics76419253_laics
lake85741603_la_ke
lame66849293_la_me
lanai5319573_lanai
lanate6421263_lanate
lancers93616643_lancers
lancets93411163_lancets
land56337313_lan_d
landed84619243_landed
lander74028483_lander
lands65426903_lands
lanes54946793_lanes
lang56637383_lan_g
langue71012173_langue
lank84734453_lan_k
lanker104123003_lanker
lanky125517483_lanky
lanner64920603_lanner
lanose6313593_lanose
lapse74917683_lapse
larch105919793_larch
laree56036293_laree
large65325463_large
lase46148513_la_se
latch104620463_latch
late47560483_la_te
lathe85626713_lathe
latke94817093_latke
latte55426303_latte
launces9329003_launces
launch11368063_launch
lave75642143_la_ve
laze136235053_la_ze
lense54523433_lense
liane54720663lian_e
lice66045063_l_ice
line46965573_lin_e
llano5910603llan_o
llanos6108333llanos
lone45849133_lon_e
longe66626463_longe
luce65132573_l_uce
lunch104917243_lunch
lune47140493_lun_e
lunge65323803_lunge
lynch13468983_lynch
mace87345793_ma_ce
malice104818483malice
manche133515103_manche
mane65052033_man_e
mange84930193_mange
manse75528233_manse
meanie83718393meanie
melange1038363melange
menace103216943menace
mince95325233_mince
nances83618643_nances
nancy105214923_nancy
nonce75719823_nonce
nuanced1036203nuanced
nuances938523nuances
once65423083__once
orange74016323orange
ounce77019933_ounce
pace86345773_pa_ce
palace104516913palace
pane64950293_pan_e
panne76623653_panne
parlance1248723parlance
peace95026083pea_ce
penance11313443penance
pence94924453_pence
placed114318003pla_ced
placer105117743pla_cer
places104323703pla_ces
placet103923673pla_cet
plack135017843pla_ck
plage84520403pla_ge
plague93610853plague
plaices11411143plaices
plan65833943plan__
planar84212713planar
planate9314573planate
planches153111863planches
planchet152511963planchet
planed94420913planed
planer84122653planer
planes85028083planes
planet84228353planet
plank115221143plan_k
planked143512283planked
planks124116753planks
planned103810153planned
planner93511623planner
plans75731273plan_s
plant75437113plan_t
planted103516123planted
planter94017803planter
plants84921803plants
plaque17317643plaque
plate74635113pla_te
plench134010813plench
pliancy1435593pliancy
plunge93811053plunge
ponce95222513_ponce
pounce105214093pounce
pranced123714043pranced
prancer113613383prancer
prances113618773prances
prince104114763prince
quince173910133quince
race66746263_ra_ce
rances84625443_rances
ranch105019793_ranch
ranee55438103_ranee
range64728413_range
relace83122153rela_ce
reliance10310473reliance
romance11311083romance
saice75424053_saice
sane45954343_san_e
sauce75121653_sauce
scarce104013633scarce
sconce104711723sconce
seances93015343seances
silane62718053silan_e
silence9310213silence
since75024173_since
slack115021763sla_ck
slainte738543slainte
slake93724053sla_ke
slander84015443slander
slang66324023slan_g
slanged94112853slanged
slangs75615343slangs
slangy105411393slangy
slank95822773slan_k
slant55238703slan_t
slanted83514743slanted
slants64819083slants
slanty95114843slanty
slatch114510533slatch
slate55438283sla_te
slave84224033sla_ve
slice74925823sl_ice
sluice849513sluice
solace83415823sola_ce
sonance9310313sonance
space95325673spa_ce
spancel1147363spancel
spence103813793spence
stances93715963stances
stanch113812373stanch
stane55933003stan_e
tace65342513_ta_ce
tenace82715693tenace
thane86122533than_e
thence112010843thence
tolane64316583tolan_e
trace75829613tra_ce
tranced104414173tranced
trances93919643trances
tranche123312223tranche
ulan46527393ulan__
ulans54921303ulan_s
ulnae55214573ul_nae
unlace82215173unla_ce
usances967373usances
usaunce9103383usaunce
valanced1475463valanced
valances1398763valances
valence1268773valence
valiance1397383valiance
vane75534693_van_e
vigilance1543593vigilance
volante1038513volante
wane76344723_wan_e
whence14187923whence
wince105220883_wince
yince105214253_yince

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127165474.84323274.0
3Display Results5475470.1563506.4
 (SQL Overall)1786915475.37233263.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.