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

288 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
octant8121655(None) 
octan71313481octan_
octane81411631octane
octans81411141octans
octants9128731octants
cant66362032_c_ant
chant105932692_chant
cotan71521782cotan_
cotans81317922cotans
extant132714752extant
mutant8317692mutant
natant6318732natant
nutant6316382nutant
ocean71212962ocean_
oceans81211002oceans
octad81510652octa_d
octads987332octads
octal71214722octa_l
octanes91111392octanes
octanol944742octanol
octantal1044562octantal
octave11157342octave
octavo11124782octavo
octet7324062oct_et
oscitant1046902oscitant
outact8317202outact
scant79735072sc_ant
accent105116263accent
acta69524803acta__
actin74922553actin_
acting95920983acting
actins86321103actins
alant55742293_alant
ant37270793___ant
arrant6623253arrant
askant10412713askant
aslant6317753aslant
attaint7313473attaint
attent62818323attent
avant86224663_avant
bezant17814543bezant
blatant9310673blatant
botany1139263botany
brant74742173_brant
butane8313653butane
byzant2096813byzant
can57760143_c_an_
cane66653123_c_ane
cans65050853_c_ans
canst74932213_c_anst
canto74931013_c_anto
cants77036943_c_ants
canty105226803_c_anty
cart66570343_c_art
cast67159903_c_ast
cat58282343_c_a_t
cent67451013_c_ent
cetane8315283cetane
chang115418563_chang
chants115020393_chants
chanty145215823_chanty
chapt125827643_chapt
chart105038283_chart
chat95546133_cha_t
chaunt11613493_chaunt
clan65633923_clan_
clang86019313_clang
clank114719523_clank
clans75031013_clans
clapt98027173_clapt
clast76030583_clast
coact96130583_coact
coapt96131533_coapt
coast75236273_coast
coat67558353_coa_t
cobalt10317393cobalt
cocoanut1246903cocoanut
cogent9321003cogent
constant10515593constant
contact1144020683contact
content94326153content
coolant9316463coolant
coranto9311893coranto
cotenant10511793cotenant
coting94629253coting
couchant1549053couchant
count74932053_count
courant9317973courant
craft105327663_craft
crane75331603_crane
crank114819613_crank
cunt66243673_c_unt
cyan96419623_cyan_
cyano105512493_cyano
cyans105714813_cyans
decant93524223decant
detent73624483detent
distant83519953distant
docent92918683doc_ent
dopant9316133dopant
dormant102814373dormant
eclat7523603ecla_t
eluant6315093eluant
enchant12313123enchant
entrant7318873entrant
errant6618733errant
etchant1249823etchant
excitant1777353excitant
extent132714913extent
fondant11311143fondant
formant123416003formant
gelant72821673gelant
giant65430593_giant
gitano738043gitano
grant64840023_grant
hant75461593__hant
incant82418513incant
incitant10810083incitant
infant92315133infant
instant7815353instant
intact8314663intact
intent63122773intent
intrant7318753intrant
jurant134216553jurant
latent64124303latent
leant56737783_leant
levant9314493levant
litany939053litany
lochan1139093lochan_
lochans1248833lochans
meant76537213_meant
montane91313623montane
mordant10312403mordant
mutants938583mutants
nocent83217413noc_ent
oast47156323o__ast
oat39888263o__a_t
oaten55222403oaten_
oblast8613663oblast
obtain839183obtain
obtains939163obtains
obtect10129633obtect
obtest81213013obtest
obtund945583obtund
oca56731733oc_a__
ocas66729633oc_a_s
occult1038433occult
occupant1444673occupant
oceanaut1043763oceanaut
oceanic1146163oceanic
ocelot8813383ocelot
ochone11311293ochone
ocicat101412813ocicat
octadic1245713octadic
octagon1045243octagon
octagons1144493octagons
octangle1143833octangle
octanols1044553octanols
octaval1243583octaval
octaves12316963octaves
octavos12134483octavos
octets839403octets
octette946423octette
octopi1036533octopi
octroi837363octroi
octyl10136063oct_yl
octyls11135323octyls
odorant8411393odorant
often84611413often_
oftest91212003oftest
operant9317223operant
opting94514403opting
orang65119943o_rang
organ6915393organ_
organa789213organa
organs7912913organs
orient6322533orient
osculant1046953osculant
ottar54313993otta_r
ottars64112223ottars
ottava963683ottava
ourang73311063ourang
outacts9310213outacts
outadd837803outadd
outage72017533outage
outask1039103outask
outate62923403outate
outcast91013743outcast
outeat62824533outeat
outfast101412123outfast
outfit93014953outfit
outhit92818473outhit
outhunt10311043outhunt
outing74128153outing
outjut13610073outjut
outland81212343outland
outlast71015443outlast
outlet63728683outlet
outman83115033outman_
outmans92413283outmans
outpaint10311773outpaint
output8712853output
outran63218893outran_
outrang83813953outrang
outrank112611973outrank
outsang83411273outsang
outsat62920283outsat
outset64027453outset
outsit63620893outsit
outvaunt1145133outvaunt
outwait10411763outwait
outwent10311363outwent
outwit93014593outwit
oxcart1539523oxcart
oxidant1547363oxidant
oxtail1337653oxtail
pant66061263__pant
patent84524923patent
peccant13311733peccant
pedant9319493pedant
plant75437113_plant
pliant83918823pliant
portent93619643portent
potent84223353potent
quant143624813_quant
rant45864683__rant
ratan53722663ratan_
ratans63819373ratans
ratany93411873ratany
reactant10311433reactant
recant83228683recant
reptant92817073reptant
retint65633443retint
riant55833153_riant
saltant7316773saltant
satang75711563satang
savant9416043savant
scan65530453sc_an_
scans74625103sc_ans
scants85219723sc_ants
scanty114014663sc_anty
scart76139773sc_art
scat65848373sc_a_t
scatt76030093sc_att
scent75831623sc_ent
secant84023293secant
sejant133114483sejant
sextant142911963sextant
slant55238703_slant
socman1039813socman_
sonant6621953sonant
soutane7312063soutane
stand65923283_stand
stane55933003_stane
stang66424683_stang
stank95823303_stank
start55642313_start
stat47352693_sta_t
statant7313123statant
stent55634513_stent
stint57037663_stint
stunt55328173_stunt
tact67349033__tact
taint55542283__taint
tan37167573__tan_
tang56138673__tang
tank85134023__tank
tans46154823__tans
tanto55724943__tanto
tart47566183__tart
tat37690293__ta_t
taunt55532283__taunt
taut47048963__taut
tenant6322473tenant
tent46159863__tent
tetany959843tetany
tint46758863__tint
titan53318173titan_
titans63414913titans
titrant7315193titrant
truant6315783truant
tyrant9315333tyrant
vacant11415133vacant
volant9316323volant
volitant1147863volitant
want76156173__want
witan83816503witan_
witans93412933witans

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 Limit1127162885.50020493.8
3Display Results2882880.0933096.8
 (SQL Overall)1786912885.96929936.5
 
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.