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

150 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
ogled7591596(None) 
gled65631141_gled
ogle56325051ogle_
ogler65917441ogler
ogles65223181ogles
oiled64429471oiled
abled86926832abled
aged67334252ag_ed
aglee65728492aglee
aglet65534142aglet
agley96917332agley
ailed66240282ailed
angled84219092angled
argled85314552argled
axled135315812axled
baled85436442baled
bled75729312_bled
bogged116019282bogged
boggled12409002boggled
bogle85821682bogle_
bogles95020832bogles
boiled95020952boiled
bolled94722652bolled
bowled125018142bowled
bugled104918132bugled
coaled95022712coaled
cogged116416612cogged
coiled95123942coiled
coled85540762coled
cooled95224592cooled
cowled125218392cowled
deled75326542deled
dogged106017702dogged
dogleg936322dogleg
dogsled1035192dogsled
doiled84817292doiled
doled75430912doled
dolled83518072dolled
eagled82914042eagled
egged85114392egged
filed95331902filed
fled85429772_fled
foaled104515962foaled
fogged125518372fogged
foiled104618402foiled
fooled104317822fooled
fouled104315972fouled
fowled133914102fowled
fugled114813692fugled
gaed66031512_gaed
ged57044532_g_ed
geed65435502_geed
geld65828432_geld
gied64631982_gied
glad65624012_glad
glede75517832_glede
gleds75417892_gleds
glee55239062_glee
gleed75320572_gleed
gleg66219802_gleg
glen56027202_glen
gley85724652_gley
glued75118362_glued
goaled85014362goaled
goggled11348952goggled
goglet84618582goglet
gold65430162gol_d
golem8416112golem
golfed11569762golfed
gored75227082gored
haled95335822haled
hogged125817772hogged
holed95634132holed
howled134014972howled
idled74915212idled
igged86012762igged
isled64615992isled
jogged166015922jogged
joggled17398432joggled
jowled174210802jowled
led46254552__led
logged96622942logged
lolled74315822lolled
mobled113213182mobled
mogged115215392mogged
moguled1135932moguled
moiled94318862moiled
muled85824432muled
naled65525052naled
nogged95716332nogged
oared65030652oared
offed12359162offed
ogee57629882og_ee
ogees65119142ogees
oglers74313182oglers
ogre56320742ogre_
ogres65818632ogres
ohed87825182o_hed
oiler54628282oiler
old47033462o_l_d
ole37155212o_le_
olea46532722o_lea
oleo46630482o_leo
oles46453472o_les
oohed94214212oohed
oozed154214262oozed
oped76230152o_ped
opted84914272opted
orbed85516192orbed
orle45630462orle_
orles55326212orles
outed65429062outed
outled74020342outled
owed86833872o_wed
owlet83324462owlet
owned95113232owned
paled85538722paled
piled85232992piled
pled75231432_pled
poled84934842poled
polled94022002polled
pooled94619812pooled
puled84926522puled
riled65833252riled
rogued84711472rogued
roiled74320052roiled
rolled74220242rolled
ruled65822522ruled
sled55334372_sled
sogged95518522sogged
soiled73822472soiled
soled65835172soled
souled75419822souled
tiled64832942tiled
togaed84711342togaed
togged95117512togged
toggled10428652toggled
toiled74420322toiled
toled65934922toled
tolled73819032tolled
tooled74918902tooled
unled64021072unled
vogued11457632vogued
voled95323722voled
waled94330992waled
wiled95231552wiled
wooled103715502wooled
wyled124611842wyled
yodled11389652yodled
yowled133811092yowled

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.376475242.0
2DLD Change Limit538001501.42337807.4
3Display Results1501500.0433488.4
 (SQL Overall)1786911501.84297009.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.