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

300 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
oxlip145688(None) 
oxlips1544431oxlips
blip88322772_blip
clip86924002_clip
flip96324262_flip
lip514755802__lip
olio46829672o_lio
orlop7410902orlop
oxalic1537092oxalic
oxalis1339222oxalis
oxid12815482ox_id
oxim131114042ox_im
oxlike17307472oxlike
slip67031732_slip
tulip71111692tulip
aalii5316123aalii
alif76242143_alif
alit46155693_alit
alp56641133_al_p
atrip75315743atrip
aulic74420243aulic
axil116424453ax_il
axile126020513axile
axils127217503axils
axis116127913ax_is
axle116424603axl_e
axled135315813axled
axles125219473axles
axlike17388853axlike
belie75630383belie
blimp115612943_blimp
blin67228173_blin
blips95615783_blips
bollix1538053bollix
boxily1877843boxily
boxlike20267073boxlike
calif104929103calif
caliph13311403caliph
calix145317343calix
chip116726423_chip
cilia73016763cilia
clap86429043_clap
clips96018303_clips
clipt96324273_clipt
clop86929893_clop
codlin94516433codlin
colic95726173colic
colin76231693colin
collie83621993collie
collop107312313collop
coolie83821603coolie
coulis84018753coulis
cowslip1444013cowslip
cylix17448623cylix
deli55631293deli_
delis64928543delis
dip67848983__dip
dollop9259363dollop
doolie73916833doolie
doxie136017153dox_ie
drip76223953_drip
dulia61014983dulia
equip16467263equip
exile126117653exile
exilic1597783exilic
exit114428673ex_it
felid94717173felid
fillip11268953fillip
flap96128703_flap
flic96223733_flic
flips105117743_flips
flir76422203_flir
flit76539273_flit
flop96925453_flop
folia83618933folia
folic105319323folic
folio83820883folio
follis93113903follis
foxily1947253foxily
foxlike21226223foxlike
galop84716213galop
gelid74916973gelid
genip84415203genip
gip67645363__gip
glia56423153_glia
glib79421443_glib
glim76026353_glim
glop76724633_glop
goalie7413153goalie
goblin939503goblin
gossip946433gossip
grip76127023_grip
gulp75521363gul_p
halid94424973halid
helio85321193helio
helix154413013helix
help95328923hel_p
hili75626633hili_
hip86750433__hip
holp95727553hol_p
hoolie93217773hoolie
ilia46026823_ilia
inclip1036823inclip
ixia115713213ix_ia
jalap143612473jalap
jalop144212603jalop
julep14310533julep
kalif125021363kalif
kaliph1537873kaliph
kelep116014553kelep
kelim11912543kelim
kelp105322803kel_p
kilim11711883kilim
kip97042133__kip
klik74412653_klik
kylix19416323kylix
lap58565273__lap
li29948753__li_
lib57750273__lib
lid47453513__lid
lie38264523__lie
limp88432493__limp
lin37967373__lin
lipa68425923__lipa
lipe66839733__lipe
lips67141443__lips
lis37162273__lis
lisp68926873__lisp
lit39377313__lit
lollop8238783lollop
lop58255313__lop
malic94525653malic
melic94722333melic
milia72719573milia
mollie83517103mollie
moulin8313283moulin
moxie144018123mox_ie
nip56945983__nip
nonslip946553nonslip
oasis56422553oasis
obeli73711933obeli_
obelia8329453obelia
obi57127733o_bi_
obia67923113o_bia
obis66226843o_bis
obit66837083o_bit
oblige937653oblige
oboli73712873oboli_
oculi72010793oculi_
odic74920573o_dic
ogle56325053ogl_e
ogled75915963ogled
ogler65917443ogler
ogles65223183ogles
ogling83211883ogling
ohia75719363o_hia
ohmic1237833ohmic
oi29061483o__i_
oidia6314953oidia
oil37452053o__il
oilcup1044253oilcup
oiled64429473oiled
oiler54628283oiler
oilier64417233oilier
oilily93111723oilily
oiling74925313oiling
oils46337973oil_s
oily77932253oil_y
okapi1136613okapi
old47033463o_l_d
oldie6415473oldie
olds55926573o_lds
oldy85316843o_ldy
ole37155213o_l_e
olea46532723o_lea
oleic7313333oleic
olein5316003olein
oleo46630483o_leo
oles46453473o_les
olios54520853o_lios
olive84817153o_live
olla44821173o_lla
ollas54218283ollas
omit65337373o_mit
onlay84212943onlay
online6315843online
only75319723onl_y
ontic74418573ontic
oolite63319603oolite
oolith93813243oolith
oorie53026363oorie
ootid61416693ootid
op45850163o___p
opsin7613473opsin
optic93715183optic
orbit73622063orbit
orcin72716573orcin
orgic8311823orgic
orle45630463orl_e
orles55326213orles
orlon5415003orlon
orlops847303orlops
ornis54616773ornis
orpin73415533orpin
orris54516553orris
osmic939913osmic
ossia53710403ossia
ostia52315583ostia
otic66624813o_tic
ourie54027293ourie
outlie62419523outlie
ovoid94811023ovoid
ovoli8358283ovoli_
owl66228973owl__
owlet83324463owlet
owlish1238693owlish
owls76022933owl_s
ox98242383ox___
oxbow1734443oxbow
oxen116218593ox_en
oxes116530723ox_es
oxeye1536913oxeye
oxide131210953oxide
oxidic1635943oxidic
oxids13128963oxids
oxime1498433oxime
oxims14107643oxims
oxo107322963ox__o
oxtail1337653oxtail
oxter123414093oxter
oxy136320983ox__y
ozalid1696673ozalid
palp85828573pal_p
palpi95414553palpi
pili66130353pili_
pilis75825203pilis
pip78051043__pip
plie65127393_plie
plop86625743_plop
polio75722553polio
polis74731163polis
polyp125611533polyp
poplin10413483poplin
puli65527623puli_
pulik113613303pulik
pulis74225603pulis
pulp84825353pul_p
quip154818623_quip
redip87816963redip
relic74623363relic
relit55340683relit
riflip1134723riflip
rip56851303__rip
salep77022953salep
salic73424713salic
salp64534093sal_p
scrip96619193scrip
ship95228233_ship
shlep104914833shlep
sip57656013__sip
skip105421743_skip
slap66434043_slap
slid55828983_slid
slim66631953_slim
slipe75626133_slipe
slips76023723_slips
slipt76627483_slipt
slit46250103_slit
slop66533873_slop
snip66424653_snip
soli46637003soli_
solid65025073solid
split75729013split
strip77524333strip
syli74318983syli_
sylis84316023sylis
tali46837163tali_
telia55821143telia
telic76019823telic
thrip103012183thrip
tip56551223__tip
toxic145315623tox_ic
toxin124716713tox_in
toxoid1438153toxoid
trip66830393_trip
tulips8137253tulips
unclip1046993unclip
unhip10178823unhip
unlit55025463unlit
unrip72012863unrip
unzip16207623unzip
uplit76020803uplit
valid94618383valid
whip125521843_whip
woolie93514483woolie
xi98128163_x_i_
xis106935333_x_is
yelp95621353yel_p
yip87241173__yip
zip146636223__zip

Search took 8 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 Filter178691836670.1101624463.6
2DLD Change Limit836673007.32611420.6
3Display Results3003000.1561923.1
 (SQL Overall)1786913007.59223536.7
 
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.