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

274 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
obtain83918(None) 
obtains939161obtains
abstain947252abstain
attain6311752attain
blain75421792_blain
bobtail1146552bobtail
brain76229382_brain
contain9315822contain
detain74617382detain
obtained1136532obtained
obtainer1045792obtainer
octan71313482octa_n
ordain7810402ordain
outgain81010742outgain
outlain71212612outlain
outsin63617552outsin
oxtail1337652oxtail
reobtain1044622reobtain
retain64523282retain
stain55727932_stain
tain45548072__tain
abating10413973abating
abatis84317933abatis
abstains1047323abstains
actin74922553act_in
again65218113_again
ain37579093___ain
amain74922883_amain
attains7310983attains
attaint7313473attaint
atwain937813atwain
baaing94916163_baaing
bail65042803_b_ail
bairn77515533_b_airn
bait66556003_b_ait
ban58366833_b_a_n
bani65334953_b_ani
barn66444643_b_arn
basin75026923_basin
batik11614733_batik
bating95132253_bating
baton75822423_baton
bean66443863_bea_n
begin85117353_begin
betaine9413783betaine
bin56658633_b__in
blains84516373_blains
blawn106813703_blawn
blin67228173_b_lin
boating103721303boating
bobbin93410723bobbin
bobtails1245193bobtails
bodkin1338923bodkin
boffin14359053boffin
bogan87519003boga_n
bota66236503bota__
botanic1159583botanic
botany1139263botany
botas75328783bota_s
botulin947653botulin
boudin9412373boudin
bowfin14338353bowfin
braid85822263_braid
brail75525553_brail
brains85125473_brains
brainy114815643_brainy
bran65740383_bra_n
brawn106018563_brawn
brin67038193_b_rin
bruin75818333_bruin
burin75626063_burin
cain65643913__cain
captain112111053captain
catkin123512373catkin
catlin83819073catlin
certain92612213certain
chain105723673_chain
citrin82615403citrin
cocain101315013cocain
contains10316533contains
cortin82423143cort_in
cotan71521783cota_n
curtain9319793curtain
cutin75022773cut_in
destain8412083destain
detail74516433detail
detains83716093detains
detrain8412253detrain
distain8313783distain
dobbin11339513dob_bin
domain9511323domain
drain65222893_drain
elain55324703_elain
entail61114343entail
entrain7313073entrain
estrin6315923estrin
etamin81311853_etamin
fain75840563__fain
fountain1144923fountain
foxtail1745383foxtail
fusain958643fusain
gain56042163__gain
gittin72910553gittin
goban84414073gob_a_n
goblin939503gob_lin
grain65126253_grain
gratin74520583gratin
hatpin112610603hatpin
hoatzin1943913hoatzin
hobnail1243973hobnail
isatin6412213isatin
kain85334293__kain
lain46146283__lain
lattin64316223lattin
litai55216363litai_
lobation102110553lobation
lobefin1244603lobefin
lutein6311263lutein
main65345503__main
matin75132853mat_in
mattin84416633mattin
mortmain1244563mortmain
mountain1046113mountain
oaten55222403oat_en
oba57531553ob_a__
obas65730933ob_a_s
obeah1038993obea_h
obeahs1135863obeahs
obeli73711933obeli_
obelia8329453obelia
obeying1336543obeying
obi57127723ob__i_
obia67923103ob__ia
obias76116853obia_s
obis66226833ob__is
obit66837073ob__it
oblast8613663oblast
oblate82214743oblate
oblation1039863oblation
oboli73712873oboli_
obtainers1144853obtainers
obtaining1236773obtaining
obtect10129633obtect
obtest81213013obtest
obtund945583obtund
obtuse8147483obtuse
ocean71212963ocea_n
octad81510653octa_d
octadic1245713octadic
octads987333octads
octagon1045243octagon
octal71214723octa_l
octane81411633octane
octans81411143octans
octant81216553octant
octave11157343octave
octavo11124783octavo
oestrin7312233oestrin
often84611413oft_en
olefin937583olefin
olein5316003o_lein
ontic74418573ont_ic
ootid61416693oot_id
opsin7613473o_psin
optic93715183opt_ic
opting94514403opt_ing
option83612713option
orating83520323orating
oration71617713oration
orcein838183orcein
orcin72716573o_rcin
ordains879653ordains
organ6915393orga_n
origin7311033origin
orpin73415533o_rpin
ossein636593ossein
ostia52315583ost_ia
otic66624813o_t_ic
ottar54313993otta_r
ottars64112223ottars
ottava963683ottava
ouabain944943ouabain
outact8317203outact
outadd837803outadd
outage72017533outage
outask1039103outask
outate62923403outate
outbid91411853outbid
outdid81210913outdid
outearn7310683outearn
outfawn1335983outfawn
outfind1139563outfind
outfit93014943outfit
outgains9810163outgains
outgrin8810543outgrin
outgun7349643outgun
outhit92818463outhit
outing74128153out_ing
outjinx2135813outjinx
outlaid81110653outlaid
outlie62419523outlie
outline72321333outline
outman83115033outman
outpaint10311773outpaint
outran63218883outran
outrig72812843outrig
outring84021013outring
outrun63213293outrun
outsaid81210923outsaid
outsail71411413outsail
outsing83320463outsing
outsins73417863outsins
outsit63620883outsit
outvie92412793outvie
outwait10411763outwait
outwind1139153outwind
outwit93014583outwit
ovation101510023ovation
oxtails1436383oxtails
pain65647243__pain
papain10313793papain
patin76832853pat_in
pertain92714963pertain
plain74823303_plain
postin83521033post_in
preobtain1343993preobtain
rain46251733__rain
ratan53722663rata_n
ratlin64116523ratlin
regain74517763regain
remain85919863remain
reobtains1144433reobtains
retail65522073retail
retains74522253retains
retrain7615423retrain
robbin103611173rob_bin
robin74820273rob__in
rutin55421343rut_in
sain45551293__sain
satin55935213sat_in
sextain14257093sextain
slain54923573_slain
sprain83614863sprain
staid66722073_staid
staig65519633_staig
stains64923653_stains
stair54719933_stair
statin63921463_statin
stein54620533_stein
strain64919573strain
sustain738763sustain
swain84919053_swain
tail45443653__tail
tains54936323__tains
taint55542283__taint
takin94921303__takin
tan37167563__ta_n
tarn46842723__tarn
thin76732383__thin
tin36362173__t_in
titan53318173tita_n
titian62512663titian
train56529113_train
twain86313623_twain
twin76023083__twin
tyin76424003__tyin
vain75233003__vain
vitamin1237413vitamin
vitrain1038943vitrain
voltaic1245453voltaic
wain75840193__wain
witan83816503wita_n
within123611383within
zeatin15412823zeatin

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.1401276364.3
2DLD Change Limit1127162746.18618221.1
3Display Results2742740.0803425.0
 (SQL Overall)1786912746.40627894.3
 
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.