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

129 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
olefines113732(None) 
olefine1038021olefine_
olefins1037491olefin_s
oleines7313391ole_ines
alexines15258502alexines
defines114118682_defines
olefin937582olefin__
olefinic1343092olefinic
oleine6313792ole_ine_
oleins6313522ole_in_s
olivines1137472olivines
refines105426342_refines
adenines9310193adenines
affines1339483_affines
alanines8314803alanines
alevins102110583alevin_s
alewives1444283alewives
alexine142410543alexine_
alexins141910663alexin_s
algerines1069083algerines
alines65735223al__ines
alkines114415733al_kines
alpines94016193al_pines
alumines10411683alumines
balefires1444813balefires
beefiness1435583beefiness
beelines103312803beelines
blennies1056933blennies
bluefins1345113bluefin_s
bluelines1145833bluelines
clevises1336903clevises
clines84926043cl__ines
codeines113114523code_ines
colicines13311203colicines
confines13315653confines
defies104624053_defi_es
defiles114016843_defiles
define104718143_define_
defined123813823_defined
definer114413773_definer
definers124211193_definers
delaines9312963delaines
diolefins1344123diolefin_s
dolerites101410893dolerites
elegies81312903elegi_es
elegises9128823elegises
elegizes18137103elegizes
elfins94810943el_fin_s
emetines10611053emetines
eserines8413743eserines
exines135715803__exines
felines104718073_felines
fines86644263___fines
flamines13311643flamines
flavines1437893flavines
gleyings13283653gleyings
glycines1445083glycines
golfings13304873gol_fings
lawines103313563_lawines
leafiness1236483_leafiness
lefties10312073_lefties
lenes54738523_le__nes
lenites7818443_lenites
leones64417723_le_ones
leucines1037273_leucines
levies93919863_levi_es
levins94514653_levin_s
lewises1039133_lewises
lines57054573_l__ines
lobefins1344823lobefin_s
lobelines1138563lobelines
lovevines1544003lovevines
lupines93912503_lupines
lysines10369093_lysines
myelines1337123myelines
obelises1039103obelises
obelizes1937513obelizes
offices1536243o_ffices
offings14285833o_ffings
oldies7314423ol_di_es
oldwives1542463oldwives
oleates7417833ole_ates
olein5316003ole_in__
olives94313953ol__ives
olivine1038843olivine_
ologies8615023ologi_es
opalines10311423opalines
openings1134813openings
opines84820703o__pines
ordines83014903o_rdines
oreides8312023ore_ides
orifices1346483orifices
orpines94414793o_rpines
oscines9310363o_scines
outfinds1235643outfinds
outfires1139863outfires
outlines82418093outlines
overmines14312683overmines
ovines94614343o__vines
oxazines2434073oxazines
pelerines11311843pelerines
polemizes2248153polemizes
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
redefines1347413redefines
refiles104122423_refiles
refinds114512123_refinds
refine95225693_refine_
refined114720003_refined
refiner105316913_refiner
refiners114713313_refiners
refires104820313_refires
refixes174813173_refixes
relines75331323_relines
repines94927383_repines
retines75134673_retines
rexines144719153_rexines
seines65029903_se_ines
serines74229543_serines
solanines9310083solanines
solecises1189103solecises
solecizes2087863solecizes
theines104013233the_ines
tolidines1046883tolidines
ulexites1534943ulexites
venines103516613_venines
voleries11313233voleri_es
wolverines1654223wolverines

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621296.40622816.4
3Display Results1291290.0462804.3
 (SQL Overall)1786911296.87226002.8
 
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.