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

285 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
octave1115734(None) 
octane81411631octane
octaves12316961octaves
octavo11124781octavo
active11313742active
cave95941262_c_ave
clave105420152_clave
crave105626312_crave
octad81510652octa_d
octads987332octads
octal71214722octa_l
octan71313482octa_n
octanes91111392octanes
octans81411142octans
octant81216552octant
octaval1243582octaval
octavos12134482octavos
ottava963682ottava
outage72017532outage
outate62923402outate
outgave11259562outgave
outrave102614412outrave
stave85324992_stave
acetate92514753acetate
acta69524803acta__
actable11313473actable
actives12311523actives
actuate9311443actuate
acuate8315633acuate
agave95314033_agave
antae56828293anta_e
aortae65115473aorta_e
ave67748703___ave
behave14209013behave
betake124512703betake
brave104925503_brave
butane8313653butane
cade76443923_c_ade
cafe95230323_c_afe
cage75339063_c_age
cake105439963_c_ake
calve105919923_calve
came87648753_c_ame
cane66653123_c_ane
cape87242783_c_ape
care66968373_c_are
carve106227753_carve
case65848083_c_ase
cate66254603_c_ate
caved116227563_c_aved
caver105629063_c_aver
caves105639703_c_aves
cavie104621593_c_avie
cavy125920003_c_avy
cease75227653_cease
cetane8315283cetane
chafe135117353_chafe
chape125221143_chape
chare105231983_chare
chase105127123_chase
chive135117623_chive
clade85821013_clade
claver113816973_claver
claves115020063_claves
clavi104912923_clavi
cleave114212513cleave
clove105619443_clove
coactive1598623coactive
coatee84327223coatee
cockade1638133cockade
comade114415323comade
comae97128423coma_e
comake144413423comake
comate104124843comate
concave1439373concave
conclave1556403conclave
costae85319683costa_e
costate94019273costate
costive12312843costive
cotan71521783cota_n
cotans81317923cotans
cote66648733cot__e
cottae84615703cottae
cottage104210573cottage
cotype1346823cotype
cove95837073_c_ove
cowage12310673cowage
coxae146115183coxa_e
crake114823523_crake
crane75331603_crane
crape96128443_crape
crate76537403_crate
craved125417773_craved
craven114113933_craven
craver114618473_craver
craves115825393_craves
craze165221463_craze
curve104920023_curve
dative10311813dative
deave95022333_deave
dictate10311663dictate
dockage1535723dockage
dotage82711613dotage
drave95219273_drave
eave75733583__eave
ecotage1036883ecotage
ectases92911673ectases
ectype1334283ectype
enclave1257533enclave
estate64719763estate
etape74413703_etape
exclave1945193exclave
fave105532963__fave
fictive1537023fictive
footage1148843footage
forgave1435853forgave
gave84634053__gave
grave94624873_grave
greave104611493greave
have106137073__have
heave114521813_heave
hectare1238473hectare
hostage113111233hostage
hotcake1644543hotcake
intake10510863intake
knave12389463_knave
lactase937963lactase
lactate9312703lactate
lave75642143__lave
leave84723723_leave
locale83915653loc_ale
locate83919843loc_ate
locative1338683locative
lockage1436613lockage
metage93114453metage
metate82720533metate
montage101211713montage
montane91313623montane
motive113112143motive
mutase82811993mutase
mutate83017483mutate
native9613013native
nave75732313__nave
nictate9310223nictate
noctule936083noctule
notate63217863notate
nutate63017373nutate
oatcake1345363oatcake
oaves84925613o__aves
oblate82214743oblate
obtain839183obtain
obtuse8147483obtuse
oca56731733oc_a__
ocas66729633oc_a_s
ocean71212963ocea_n
oceans81211003oceans
ochone11311293ochone
ochre103411593oc_hre
ocreae83310273ocreae
ocreate93711743ocreate
octadic1245713octadic
octagon1045243octagon
octangle1143833octangle
octanol944743octanol
octants9128733octants
octet7324063oct_et
octets839403octets
octette946423octette
octopi1036533octopi
octroi837363octroi
octuple1153993octuple
octyl10136063oct_yl
octyls11135323octyls
ogive9379093o_give
ohmage1295063ohmage
oleate6318883oleate
olive84817153o_live
onstage838363onstage
opiate8513463opiate
optative1347653optative
optime1079353optime
orate55133303o_rate
orective1339353orective
ornate6315143ornate
ottar54313993otta_r
ottars64112223ottars
ottavas1093483ottavas
outact8317203outact
outadd837803outadd
outages82317323outages
outask1039103outask
outbake13310773outbake
outbrave1357133outbrave
outbye1147913outbye
outdare83113403outdare
outdate83016423outdate
outface123011973outface
outgaze17239223outgaze
outgive11199253outgive
outlie62419533outlie
outlive102513033outlive
outlove102410243outlove
outmove12238713outmove
outpace112613023outpace
outrace92418553outrace
outrage82616893outrage
outrate72323183outrate
outraved122511933outraved
outraves112313833outraves
outre53922203out_re
outsee63121803outsee
outtake11310793outtake
outvie92412803outvie
ovate84214393o_vate
oxtail1337653oxtail
pave96133893__pave
pectase112410363pectase
pectate112214693pectate
portage103013643portage
postage103214853postage
potage92715903potage
pottage103310603pottage
rave75542093__rave
reave84528023_reave
regave104713383regave
repave114813873repave
retake104718533retake
retape83917683retape
rootage839053rootage
rotate63320343rotate
save75741363__save
scale74629143sc_ale
scape96921843sc_ape
scare75334463sc_are
scathe114414993scathe
schav1338313schav_
schavs1436493schavs
scrape105917573scrape
scrive115414943scrive
scutage1036333scutage
scutate9310323scutate
setae56026223seta_e
shave114425893_shave
sheave124514003sheave
slave84224033_slave
sleave94714153sleave
soave84219053_soave
socage91012123soc_age
soccage1236283soccage
soutane7312063soutane
stade64825303_stade
stage65330193_stage
stake95927533_stake
stale55637103_stale
stane55933003_stane
stare54440263_stare
starve94613743_starve
state56237333_state
staved103918053_staved
staves94525193_staves
stove85220253_stove
suave83519873_suave
tace65342513__tace
tae38267053__ta_e
take84739263__take
tale46154163__tale
tame66343663__tame
tape64538153__tape
tare45957623__tare
tate44748603__tate
tav66043213__tav_
tavs75630973__tavs
thrave126010273thrave
toccate1138773toccate
trave85223033_trave
untame82513603untame
uptake1236963uptake
vitae84217633vita_e
vocative1637913vocative
voltage1136863voltage
votive12348933votive
watape11208483watape
wave105234733__wave
weave115218533_weave
zouave1833573zouave

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 Filter1786911127160.373479064.3
2DLD Change Limit1127162855.62620034.8
3Display Results2852850.0933064.5
 (SQL Overall)1786912856.09229332.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.