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

211 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
olefin93758(None) 
olefine1038021olefine
olefins1037491olefins
olein5316001ole_in
alevin92511512alevin
alexin132311482alexin
bluefin1245122bluefin
diolefin1244142diolefin
elfin84312462el_fin
levin84816412_levin
lobefin1244602lobefin
olefines1137322olefines
olefinic1343092olefinic
oleic7313332ole_ic
oleine6313792ole_ine
oleins6313522ole_ins
acetin8314693acetin
alanin6317273alanin
aldrin7311243aldrin
alef76340693alef__
alefs87319663alef_s
alevins102110583alevins
alexia132910463alexia
alexine142410543alexine
alexins141910663alexins
algin65718763al_gin
aloin55227423al_oin
alumin8513543alumin
beefing133911473beefing
befit105222663_befit
begin85117353_begin
biffin14369103biffin
blain75421793bl_ain
blin67228173bl__in
bluefins1345113bluefins
boffin14359053boffin
boleti8413403boleti_
bowfin14338353bowfin
chefing16359033chefing
clean75420413cle_an
clef97028183clef__
clefs106616243clef_s
cleft106222853clef_t
clefting14347583clefting
clefts114610163clefts
cleping123310423cleping
cleric10612133cleric
clerid9312413clerid
clevis1158963clevis
clewing13359583clewing
codein94916723code_in
coffin14339813coffin
colicin11313743colicin
colin76231693col__in
cretin82917913cretin
defi86321493_defi_
define104718143_define
defis96717503_defis
diolefins1344123diolefins
doleful1146333doleful
dolphin1345533dolphin
elain55324703el_ain
elegit71212893elegit
elemi7312503elemi_
elemis8312383elemis
eleven988303eleven
elevon977953elevon
elfins94810943el_fins
eloin55923203el_oin
emetin8613463emetin
fin66458043___fin
flavin1239303flavin
fleeing113511293fleeing
flexing18358993flexing
flexion1735073flexion
fleying14329873fleying
florin9312653florin
folacin1238053folacin
glean65818203gle_an
glen56027203gle__n
gleying12318433gleying
globin9309723globin
glycin1235963glycin
golfing12368943gol_fing
haemin113412663haemin
hemin103620933_hemin
kefir12457913_kefir
kelvin13117323kelvin
lain46146283_l_ain
lapin75222923_lapin
layin84720333_layin
leafing113313583_leafing
lean46345243_le_an
learn55322663_learn
leben7314853_leben
lectin82515013_lectin
left76340483_lef_t
lefts86517813_lefts
lefty115613563_lefty
leggin8268593_leggin
legion75712983_legion
legit61323503_legit
lei36846383_le_i_
leis45739603_le_is
leman75622603_leman
lemon75618183_lemon
lenis56326863_lenis
leptin82512333_leptin
lesion64715063_lesion
leucin839113_leucin
levins94514653_levins
levis85818553_levis
lewis85315843_lewis
lexis125916033_lexis
lin37967383_l__in
linin58025523_linin
lipin75518893_lipin
loafing11319793loafing
lobefins1344823lobefins
login66025003_login
loin46838723_l_oin
lomein8410203lomein
lupin75215843_lupin
lysin84512783_lysin
malefic1486323malefic
moleskin1444083moleskin
muffin14298873muffin
myelin1138973myelin
obeli73711933obeli_
obelia8329453obelia
obeying1336543obeying
obtain839183obtain
ocean71212963oce_an
odeon6411483ode_on
offing13368643o_ffing
oilskin1144473oilskin
olden65114853ol_den
oldie6415473ol_die
ole37155213ole___
olea46532723ole__a
oleate6318883oleate
oleines7313393ole_ines
oleo46630483ole__o
oleos55419683ole_os
oles46453473ole__s
oleum73613323ole_um
oleums8358783oleums
olio46829673ol__io
olivine1038843olivine
omen66828183ome__n
omening10310103omening
open66427003ope__n
opening1039933opening
operon8811773operon
opsin7613473o_psin
orcein838183orcein
orcin72716573o_rcin
ordain7810403ordain
origin7311033origin
orpin73415533o_rpin
ossein636593ossein
outfind1139563outfind
outfit93014953outfit
outsin63617563outsin
oven76624143ove__n
overfit132610963overfit
overing111918053overing
oxen116218593oxe__n
pein65834943_pe_in
pekin111514423_pekin
plain74823303pl_ain
pleon74216383ple_on
poleis86018353pole_is
polemic13311253polemic
poleyn1157323pole_yn
prefix18356853prefix
pterin81014153pterin
puffin141149003puffin
redfin10310223redfin
reefing114016863reefing
refind104717073_refind
refine95225693_refine
refit84230063_refit
refix155212483_refix
rein46040893_re_in
renin54830033_renin
repin75324703_repin
resin54131053_resin
rewin85623963_rewin
rolfing113710653rol_fing
selfing112911623selfing
serin55434443_serin
skein94814413ske_in
slain54923573sl_ain
slewing113311353slewing
solanin7311943solanin
solei55624343sole_i_
solemn838643sole_mn
stein54620543ste_in
thein85919023the_in
tholepin1344113tholepin
tiepin839343tiepin
tiffin12327933tiffin
tolidin839243tolidin
vein75625753_ve_in
venin85118663_venin
volutin1098103volutin
welkin1337313welkin
wolfing14277893wol_fing
yeelin939343yeelin
zein135620603_ze_in

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.406440125.6
2DLD Change Limit1127162115.47020606.2
3Display Results2112110.0633349.2
 (SQL Overall)1786912115.93930087.7
 
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.