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

474 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
glaive1035793(None) 
glaire74411301glaire
glaived12375971glaived
glaives11347831glaives
alive85722512al_ive
clave105420152cla_ve
elative10312452elative
gave84634052g_a_ve
give85829362g__ive
glace87420162gla_ce
glade75121962gla_de
glaiket1238362glaiket
glair65313552glai_r
glaired9387752glaired
glaires84010142glaires
glairs75211332glairs
glairy10448272glairy
glance94312312glance
glare65222962gla_re
glaze155418162gla_ze
glide74521602gl_ide
glime85620192gl_ime
glove94516292gl_ove
grave94624872gra_ve
lave75642142_la_ve
live76541002_l_ive
naive85116212_naive
olive84817152ol_ive
plaice10311552plaice
slave84224032sla_ve
waive114214602_waive
ablative1348243ablative
active11313743active
agave95314033aga_ve
aglare7312433agla_re
aide56045013__aide
aiver85725163__aiver
alae45643753ala__e
alane56135613ala_ne
alanine7316863alanine
alate55340333ala_te
albite8313313albite
alcaide1088453alcaide
alcove1178093alcove
alike95523963al_ike
aline57243153al_ine
alkie95520033alki_e
alkine104916803alkine
alpine84417373alpine
alsike1047913alsike
alvine94614583alvine
amative12311733amative
arrive91311793arrive
ave67748703__a_ve
baize164717393_baize
belive115415303belive
blade85923333bla_de
blae66134643bla__e
blain75421793blai_n
blains84516373blains
blame95625493bla_me
blare75826233bla_re
blase75524233bla_se
blate75933783bla_te
blaze165520833bla_ze
blite76225353bl_ite
braise84318753braise
braize174113113braize
brave104925503bra_ve
calve105919923_calve
carve106227753_carve
cave95941263_ca_ve
cavie104621593_cavie
chaine115119223chaine
chaise114916413chaise
chive135117623_chive
clade85821013cla_de
claim95616913clai_m
claimed12298833claimed
claimer11279883claimer
claims105211573claims
claque17338563claque
clause84311503clause
claver113816973cla_ver
claves115020063cla_ves
clavi104912923cla_vi
clavier1239173clavier
cleave114212513cleave
clime95720893cl_ime
cline76428533cl_ine
clove105619443cl_ove
crave105626313cra_ve
dative10311813dative
deave95022333dea_ve
delaine8314793delaine
derive103817043derive
dilative1239523dilative
dive85634783__dive
drave95219273dra_ve
drive95318003_drive
eave75733583_ea_ve
egalite8311563egalite
elain55324703elai_n
elains64919853elains
elapine9310673elapine
elapse857523elapse
elate55335883ela_te
elatives1139783elatives
elide64922653el_ide
elite56230183el_ite
elusive1057003elusive
endive103310473endive
evasive1344663evasive
fauve114712073_fauve
fave105532963_fa_ve
five107629753__five
flail85316183flai_l
flailed1137303flailed
flails94313003flails
flair86114123flai_r
flairs95711913flairs
flake125119973fla_ke
flambe13489153flambe
flame105124443fla_me
flange103411973flange
flare84823633fla_re
flavin1239303flavin
flavine1338453flavine
flite85424963fl_ite
fraise94214913fraise
gable85325523g_able
gadje1457743g_adje
gae46457703g_a__e
gaffe124111653g_affe
gage65936103g_a_ge
gaily95020973g_aily
gain56042163g_ai_n
gained84617463g_ained
gainer74117493g_ainer
gains65729513g_ains
gait56150193g_ai_t
gaited84416923g_aited
gaiter73819503g_aiter
gaits65726013g_aits
gale56347323g_a_le
galeae74717453galeae
galere73716693galere
galilee8312213galilee
galiot72322593galiot
galore73514873galore
gambe106219213g_ambe
game76644323g_a_me
gamine94620153gamine
gane55145303g_a_ne
ganev95513863g_anev
gape75134513g_a_pe
garvey13127873g_arvey
gate55746573g_a_te
gauge76117903g_auge
gauze155712973g_auze
gavel95815183g_a_vel
gaze145032413g_a_ze
gelable101710733gelable
gelate73421263gela_te
gelatine93213313gelatine
genie66124923geni_e
gibe75927793g__ibe
gie47149553g__i_e
gillie74816943gilli_e
gite55438623g__ite
given95915283g__iven
giver94921203g__iver
gives95324873g__ives
glaceed1136203glaceed
glaces94218033glaces
glacial1038143glacial
glaciate1168083glaciate
glacier103911303glacier
glacis94012133glacis
glacises1138513glacises
glad65624013gla__d
gladded11357453gladded
gladden10376313gladden
gladder10398313gladder
glades84820343glades
gladiate1057053gladiate
gladier93810993gladier
gladly11497933gladly
glads75620613gla_ds
glady105413943gla_dy
glaikit1244633glaikit
glairier944843glairier
glam76529343gla__m
glamor958193glamor
glams85822933gla_ms
glanced11439233glanced
glancer103710073glancer
glances104113143glances
gland75217713gla_nd
glandes95413833glandes
glands85314403glands
glans65125833gla_ns
glared84715203glared
glares75518873glares
glarier84112213glarier
glaring93714883glaring
glary96018543gla_ry
glass65518133gla_ss
glassed93710433glassed
glasses84414273glasses
glassie8329493glassie
glassine9329313glassine
glassy10527753glassy
glazed174711773glazed
glazer164212263glazer
glazes165315643glazes
glazier17409353glazier
glazily2035383glazily
glazing183611003glazing
glazy187410983gla_zy
glebae9407613glebae
glebe85016443gl_ebe
glede75517833gl_ede
glee55239063gl__ee
glia56423153gl_i_a
gliadine1045403gliadine
glial66715433gl_ial
glias64618493gl_ias
glib79421443gl_i_b
glided94513903gl_ided
glider84614263gl_ider
glides84518863gl_ides
gliff124915663gl_iff
glim76026353gl_i_m
glimed105312283gl_imed
glimes94717523gl_imes
glims87417673gl_ims
glint66830183gl_int
glitz154916373gl_itz
globe84917013gl_obe
gloved114811873gl_oved
glover104513533gl_over
gloves104115183gl_oves
gloze154815983gl_oze
glue55628493gl__ue
gluier7310263gluier
gluily10308293gluily
gluing83812053gluing
glume85120463gl_ume
glute66020903gl_ute
glycine1335713glycine
goalie7413163goalie
goatee73219533goatee
grace85124543gra_ce
gracile102512603gracile
grade75126093gra_de
gradine93317033gradine
grail64622873grai_l
grails77518783grails
grain65126253grai_n
grained93814273grained
grainer83714063grainer
grains74223093grains
grainy103914213grainy
gramme114210333gramme
grange83716203grange
granite82017083granite
grape84824663gra_pe
grate64932883gra_te
gratine84719193gratine
graved114818813gra_ved
gravel105313823gra_vel
graven104513523gra_ven
graver105018593gra_ver
graves104624003gra_ves
gravid113710983gravid
gravies11314093gravies
gravy125512113gra_vy
graze155820053gra_ze
greave104611493greave
greige847203greige
gride75223593g_ride
grieve1047243grieve
grime85021323g_rime
gripe84622963g_ripe
grivet103517823g_rivet
groove10438873groove
grove95219333g_rove
guaiac946153guaiac
guanine8810543guanine
guava938583gua_va
guide75019893g_uide
guile64521133g_uile
guise64717713g_uise
gunite7414403gunite
gwine95513663g_wine
gyve116215083g__yve
halide103417993halide
halite93624233halite
halve114818923_halve
have106137073_ha_ve
heave114521813hea_ve
hive106029683__hive
illative1147183illative
illite63414923illite
jive146123603__jive
knave12389463kna_ve
labile8315223_labile
lace66848473_la_ce
lade56345993_la_de
ladle66320443_ladle
laevo849363_laevo
laic65931563_lai_c
laich105920713_laich
laics76419253_laics
laid56439153_lai_d
laigh95515923_laigh
lain46146283_lai_n
lair45934153_lai_r
laird65417793_laird
laired75216813_laired
lairs55425873_lairs
laith85722103_laith
laity85318903_laity
lake85741603_la_ke
lame66849293_la_me
lamiae84817453_lamiae
lance75126723_lance
lane45153333_la_ne
lapse74917683_lapse
laree56036303_laree
large65325463_large
larine63927043_larine
larva8312493_larva
larvae938853_larvae
lase46148513_la_se
late47560483_la_te
lathe85626723_lathe
latke94817093_latke
latte55426303_latte
lav66847343_la_v_
lava76725423_la_va
laved95028593_la_ved
laver85031793_la_ver
laves86039153_la_ves
lavs76734153_la_vs
lawine93316463_lawine
laze136235053_la_ze
leave84723723_leave
liaise6310693liaise
liane54720663_liane
lice66045073_l_ice
lie38264533_l_i_e
lieve86315473_lieve
life75433743_l_ife
like86040853_l_ike
lime66244943_l_ime
line46965583_l_ine
lipe66839743_l_ipe
lire47845303_l_ire
lite47054553_l_ite
lived95523723_l_ived
liven85021733_l_iven
liver85132963_l_iver
lives86133193_l_ives
livre85613253_l_ivre
love75234763_l_ove
maile75232223_maile
maize164618563_maize
malaise9312673malaise
malice104818483malice
maline84529093maline
mauve104013273_mauve
mavie104722563_mavie
motive113112143motive
naiver94311353_naiver
naives94914223_naives
native9613013native
nave75732313_na_ve
ogive9379093_ogive
oldie6415473oldi_e
oleine6313793oleine
olives94313953ol_ives
paise75028333_paise
parve109824853_parve
pave96133893_pa_ve
place94824613pla_ce
plage84520403pla_ge
plague93610853plague
plaices11411153plaices
plaid85118303plai_d
plaided11409643plaided
plaids94312443plaids
plain74823303plai_n
plained103812233plained
plainer93811983plainer
plains85019593plains
plaint85323203plaint
plait75631573plai_t
plaited103713893plaited
plaiter93615393plaiter
plaits83816473plaits
plane74929143pla_ne
plaque17317643plaque
plate74635113pla_te
plausive1344583plausive
plie65127393pl_i_e
plosive1236673plosive
praise84419413praise
raise54828053_raise
rave75542093_ra_ve
reave84528023rea_ve
regive104814323regive
reive85522943_reive
relative11313143relative
relive95120783relive
revive124914823revive
rive75537733__rive
saice75424053_saice
saline65132703saline
saliva93110743saliva
salve85022133_salve
save75741363_sa_ve
scrive115414943scrive
shave114425893sha_ve
shavie124312423shavie
shive114423423_shive
shrive125216953shrive
skive124614123_skive
slain54923573slai_n
slainte738543slainte
slake93724053sla_ke
slate55438283sla_te
slaved104017043sla_ved
slaver94419613sla_ver
slaves95023023sla_ves
slavey124011803sla_vey
sleave94714153sleave
sleeve93411593sleeve
slice74925823sl_ice
slide64725423sl_ide
slieve9359273slieve
slime74925753sl_ime
slipe75626133sl_ipe
sliver94116593sl_iver
sluice849513sluice
soave84219053soa_ve
spavie113611383spavie
starve94613743starve
stative102612933stative
stave85324993sta_ve
strive95020963strive
suasive1037853suasive
suave83519873sua_ve
swive115316193_swive
thrive125313223thrive
trave85223033tra_ve
unlive92712333unlive
updive1234903updive
valine94623093valine
valise92917653valise
valve114515933_valve
varve115716853_varve
visive1257873visive
vive105426633__vive
votive12348933votive
waived134511283_waived
waiver124212713_waiver
waives123714183_waives
wave105234733_wa_ve
weave115218533wea_ve
wharve15456213wharve
wive105931763__wive
zaire14311993_zaire

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.376475242.0
2DLD Change Limit1127164744.78023580.8
3Display Results4744740.1563038.5
 (SQL Overall)1786914745.31233639.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.