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 “oleos” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
oleos5541968(None) 
oleo46630481oleo_
oles46453471ole_s
olios54520851olios
alecs76620732alecs
alefs87319662alefs
ales47067102ale_s
aloes54933672aloes
altos55822952altos
blebs96416152blebs
bless75917812bless
blets75324942blets
boleros9310292boleros
boles75448602bole_s
bolos75531372bol_os
clefs106616242clefs
clews105516332clews
coles76055062cole_s
coleus86818272coleus
doles67843752dole_s
fleas86423662fleas
flees85828752flees
flews115316442flews
fleys117015602fleys
floes85528142floes
foleys123810462foleys
folios93915462folios
gleds75417892gleds
glees65027592glees
glens66519852glens
gleys96514852gleys
golems939322golems
helos84928062helos
holes84748652hole_s
hollos95320632hollos
ileus54616892ileus
joles125230832jole_s
kolos94921212kol_os
leas45954182_leas
lees45455882_lees
legs56133692_legs
leis45739602_leis
leks85427602_leks
lenos56024862_lenos
lens46146492_lens
les35663072_le_s
less45635102_less
lets47147942_lets
leys76430182_leys
lobos75921842lobos
locos75822602locos
loess55714702loess
logos67225332logos
loos49051122_loos
lotos54724632lotos
moles74747922mole_s
nolos54423352nol_os
obes66036832obe_s
obeys107010642obeys
oboes75717712oboes
odeon6411482odeon
odeons739022odeons
odes57243242ode_s
oes35866192o_e_s
ogees65119142ogees
oglers74313182oglers
ogles65223182ogle_s
oilers64721192oilers
okehs12477462okehs
okes84936342oke_s
olds55926572ol_ds
ole37155212ole__
olea46532722ole_a
oleic7313332oleic
olein5316002olein
oleins6313522oleins
oleum73613322oleum
oleums8358782oleums
olio46829672olio_
ollas54218282ollas
omens75618962omens
omers76923192omers
ones46146532one_s
onos46229002o_nos
opens76118552opens
opes65942612ope_s
ordos65216202ordos
ores46056682ore_s
orles55326212orle_s
orzos143311252orzos
oses46641512ose_s
ottos54714322ottos
ouzos143210412ouzos
ovens86217452ovens
overs85224792overs
owes75137102owe_s
owlets93110392owlets
oxes116530722oxe_s
oyers87620882oyers
oyes74940132oye_s
pleas75627032pleas
plebs95814582plebs
pleon74216382pleon
pleons84213342pleons
plews105415352plews
poleis86018352poleis
polers84225642polers
poles75351002pole_s
polios84019722polios
polos76129912pol_os
rodeos75314502rodeos
roles56747982role_s
romeos84013172romeos
sleds64418852sleds
slews86220352slews
sloes54728872sloes
soles55547922sole_s
soleus64615612soleus
solos54830792sol_os
telos55424522telos
toledos8388862toledos
toles55147132tole_s
voles86234042vole_s
ylems1039262ylems

Search took 4 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 Filter178691538000.343520965.0
2DLD Change Limit538001243.09317394.1
3Display Results1241240.0631968.3
 (SQL Overall)1786911243.49951069.2
 
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.