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

236 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
olea4653272(None) 
flea75628491flea
ilea45931461ilea
lea37660181_lea
odea56224571odea
ole37155211ole_
oleo46630481oleo
oles46453471oles
olla44821171olla
plea66830601plea
ala312463602al_a
alae45643752alae
alba68328332alba
ale36572342ale_
alec66430062alec
alee46652322alee
alef76340692alef
ales47067102ales
alfa77624272alfa
alga57927602alga
alma66333022alma
area45843392area
asea46327182asea
blae66134642blae
bleak115915382bleak
blear75918682blear
bleat75737002bleat
bleb85425222bleb
bled75729312bled
blet66247672blet
blew94722432blew
bohea105013732bohea
bola66035562bol_a
bole66448692bole_
boles75448602boles
clean75420412clean
clear76219052clear
cleat76335062cleat
clef97028182clef
clew95520572clew
cola66541392col_a
cole66956112cole_
colead94114642colead
coled85540762coled
coles76055062coles
colza165112982colza
dole56550002dole_
doled75430912doled
doles67843752doles
dolma86214172dolma
fleam106017282fleam
fleas86423662fleas
fled85429772fled
flee76238792flee
flew105824252flew
flex146123472flex
fley106626852fley
foley115222302foley
folia83618932folia
fovea11310482fovea
galea64722932galea
gleam86916732gleam
glean65818202glean
gleba83910242gleba
gled65631142gled
glee55239062glee
gleg66219802gleg
glen56027202glen
gley85724652gley
glia56423152glia
golem8416112golem
hole77553392hole_
holed95634132holed
holes84748652holes
holey115626902holey
holla84918492holla
idea59122772idea
ileac75814172ileac
ileal56118082ileal
ilex115822032ilex
ilia46026822ilia
ilka87215152ilka
jole117233822jole_
joles125230832joles
kea76540912_kea
kola85124962kol_a
la219261632_l_a
lead56038852_lead
leaf76441032_leaf
leak86233712_leak
leal46043272_leal
lean46345242_lean
leap66032682_leap
lear47045952_lear
leas45954182_leas
led46254552_led
lee36068142_lee
leg46446112_leg
lei36846382_lei
lek75640302_lek
les35663072_les
let36481472_let
leu36047402_leu
lev66139422_lev
leva77020712_leva
lex107943822_lex
ley66246812_ley
lez125541312_lez
loca65527682loca
lota47233502lota
mola66035632mol_a
mole66251832mole_
moles74747922moles
oba57531552o_ba
obe56638642obe_
obeah1038992obeah
obes66036832obes
obey96521302obey
obia67923112obia
oca56731732o_ca
ocean71212962ocean
ocrea73311822ocrea
oda48133042o_da
ode47446582ode_
odes57243242odes
oe28473062o_e_
oes35866192o_es
ogee57629882ogee
ogle56325052ogle_
ogled75915962ogled
ogler65917442ogler
ogles65223182ogles
ohed87825182ohed
ohia75719362ohia
oiled64429472oiled
oiler54628282oiler
oka76926802o_ka
oke75839482oke_
okeh114615322okeh
okes84936342okes
okra86413572okra
old47033462ol_d
olden65114852olden
older65121172older
olds55926572olds
oldy85316842oldy
oleate6318882oleate
oleic7313332oleic
olein5316002olein
oleos55419682oleos
oleum73613322oleum
olio46829672olio
ollas54218282ollas
omega836382omega
omen66828182omen
omer67028392omer
one37050912one_
ones46146532ones
ope56845242ope_
oped76230152oped
open66427002open
opera7313572opera
opes65942612opes
ora37250832o_ra
orca65522772orca
ore36661832ore_
oread64619602oread
ores46056682ores
orle45630462orle_
orles55326212orles
orra46120722orra
ose38147342ose_
oses46641512oses
ossa43714162ossa
ova66823792o_va
oven76624142oven
over77227342over
owe67041032owe_
owed86833872owed
owes75137102owes
owlet83324462owlet
oxen116218592oxen
oxes116530722oxes
oyer75927652oyer
oyes74940132oyes
oyez166020352oyez
palea75028662palea
pea56657242_pea
pilea75123952pilea
plead85818462plead
pleas75627032pleas
pleat74734472pleat
pleb86123812pleb
pled75231432pled
plena75816392plena
plew97222812plew
plex137321372plex
pole65951302pole_
poleax1547992poleax
poled84934842poled
poler74431792poler
poles75351002poles
polka11310412polka
rhea75017432rhea
role45851822role_
roles56747982roles
sea36161292_sea
shea76031572shea
sled55334372sled
slew76228232slew
sola45541862sol_a
sole46053672sole_
soled65835172soled
solei55624342solei
soles55547922soles
tea37353322_tea
tela45532972tela
toea46732332toea
tola45236332tol_a
tole46052902tole_
toled65934922toled
toles55147132toles
ulema7109712ulema
ulna46317322ulna
ulva75412692ulva
urea46528052urea
uvea74712652uvea
vela75725542vela
vole75236982vole_
voled95323722voled
voles86234042voles
volta85215622volta
volva11399002volva
yea66445752_yea
ylem9217892ylem
zoea137118422zoea

Search took 2 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 Filter178691298720.330541487.9
2DLD Change Limit298722360.81036879.0
3Display Results2362360.0633746.0
 (SQL Overall)1786912361.203148537.8
 
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.