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

163 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
ogles6522318(None) 
bogles95020831bogles
ogees65119141ogees
ogle56325051ogle_
ogled75915961ogled
ogler65917441ogler
oglers74313181oglers
ogres65818631ogres
oles46453471o_les
orles55326211orles
ables75935542ables
ages55844592ag_es
aglee65728492aglee
aglet65534142aglet
aglets73915682aglets
agley96917332agley
agues64919052agues
ales47067102_ales
angles74426702angles
argles75218482argles
arles56735742arles
axles125219472axles
bales76250082bales
biles75542142biles
boggles113411822boggles
bogies94724312bogies
bogle85821682bogle_
boles75448602boles
boules84925972boules
bugles94822442bugles
cobles104622882cobles
coles76055062coles
dales66439742dales
deles65139252deles
doges75630162dog_es
dogies85022252dogies
dogleg936322dogleg
doglegs1034782doglegs
doles67843752doles
dongles93212872dongles
eagles73819162eagles
files85441272files
fogies104118062fogies
fogless1138192fogless
folles93820472folles
fugles104715782fugles
gaes56348032_gaes
gales65442482gales
gees55647882_gees
gels56836102_gels
gies55641422_gies
gled65631142_gled
gleds75417892_gleds
glee55239062_glee
glees65027592_glees
gleg66219802_gleg
glen56027202_glen
glens66519852_glens
gley85724652_gley
gleys96514852_gleys
glues65125682_glues
goes55644092_goes
goggles103510792goggles
goglet84618582goglet
goglets9379782goglets
golds75421312golds
golem8416112golem
golems939322golems
golfs95616102golfs
gores65740372gores
goxes135018262goxes
gules64831042gules
hales85449842hales
holes84748652holes
hoyles12315012hoyles
idles66720122idles
iglus6609932iglus
ingles74420872ingles
isles54220562isles
joggles164410412joggles
joles125230832joles
joules134116822joules
kales95730982kales
les35663072__les
loges66534202log_es
males75049792males
miles74645072miles
moles74747922moles
mules75034292mules
nobles83319722nobles
oases55330982oases
oaves84925612oaves
obes66036832o_bes
oboes75717712oboes
oboles83815832oboles
odes57243242o_des
odyles10348562odyles
oes35866192o__es
ogams84112682ogams
ogee57629882og_ee
ogives10367912ogives
ogre56320742ogre_
ogress7529502ogress
oiled64429472oiled
oiler54628282oiler
oilers64721192oilers
oils46337972oil_s
okes84936342o_kes
olds55926572o_lds
ole37155212o_le_
olea46532722o_lea
oleo46630482o_leo
oleos55419682o_leos
ollas54218282ollas
ones46146532o_nes
oodles73517182oodles
oozes145418712oozes
opes65942612o_pes
ores46056682o_res
orgies72316092orgies
orle45630462orle_
oses46641512o_ses
ovules938222ovules
owes75137102o_wes
owlet83324462owlet
owlets93110392owlets
owls76022932owl_s
oxes116530722o_xes
oyes74940132o_yes
pales75753802pales
peles75738082peles
piles74742612piles
pogies94123542pogies
poles75351002poles
pules74538812pules
rales54947492rales
riles55343642riles
robles85321692robles
rogues74617672rogues
roles56747982roles
rules55234252rules
sales56055592sales
socles8418452socles
soles55547922soles
tales55451372tales
teles54536002teles
tiles55542102tiles
toggles93710972toggles
togues76014242togues
toiles63923512toiles
toles55147132toles
tules54532792tules
uglies7412322uglies
vales85434262vales
vogues104011922vogues
voiles94616442voiles
voles86234042voles
wales86142832wales
wiles85437872wiles
wyles114615322wyles
yodles103714332yodles
yogees10510632yogees
yules84521582yules

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 Filter178691538000.313570897.8
2DLD Change Limit538001631.54634799.5
3Display Results1631630.0463543.5
 (SQL Overall)1786911631.90593801.0
 
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.