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 “ogle” 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
ogle5632505(None) 
bogle85821681bogle
ogee57629881ogee
ogled75915961ogled
ogler65917441ogler
ogles65223181ogles
ogre56320741ogre
ole37155211o_le
orle45630461orle
able66340532able
age47154332ag_e
agee56241492agee
agile65122262agile
aglee65728492aglee
aglet65534142aglet
agley96917332agley
agly86821802agly
ague55725922ague
ale36572342_ale
angle64528872angle
argle65421562argle
axle116424602axle
bale66353842bale
bile66147182bile
boggle104511942boggle
bogie89524102bogie
bogles95020832bogles
bole66448692bole
boule74828042boule
bugle84721942bugle
coble94823172coble
cole66956112cole
dale55643982dale
dele56843082dele
doge66233802dog_e
dogie75222792dogie
dogleg936322dogleg
dole56550002dole
dongle83612492dongle
eagle64219482eagle
file75446642file
fogie96719002fogie
fugle94915542fugle
gae46457702_gae
gale56347322gale
gee45359202_gee
gel45642432_gel
gie47149542_gie
gled65631142_gled
glee55239062_glee
gleg66219802_gleg
glen56027202_glen
gley85724652_gley
glue55628492_glue
goggle94511572goggle
goglet84618582goglet
gold65430162gold
golem8416112golem
golf85731182golf
gone55639042gone
gore55744962gore
hale76052832hale
hole77553392hole
hoyle11314412hoyle
idle55423762idle
iglu510814782iglu
ingle64120432ingle
isle45121702isle
joggle154010352joggle
jole117233822jole
joule124918202joule
kale86533752kale
loge56837192log_e
male66052292male
mile66352572mile
mole66251832mole
mule65236972mule
noble74420992noble
obe56638642o_be
oboe66822942oboe
obole75917142obole
ode47446582o_de
odyle9349592odyle
oe28473062o__e
ogam75120032ogam
ogees65119142ogees
ogive9379092ogive
oglers74313182oglers
ogres65818632ogres
oil37452052oil_
oiled64429472oiled
oiler54628282oiler
oils46337972oils
oily77932252oily
oke75839482o_ke
old47033462o_ld
olea46532722o_lea
oleo46630482o_leo
oles46453472o_les
olla44821172olla
once65423082once
one37050912o_ne
only75319722only
ooze136420602ooze
ope56845242o_pe
ore36661832o_re
orles55326212orles
ose38147342o_se
ovule839492ovule
owe67041032o_we
owl66228972owl_
owlet83324462owlet
owls76022932owls
owse76321622owse
pale66055012pale
pele65539552pele
pile65649692pile
pole65951302pole
pule65040952pule
rale45050562rale
rile45650532rile
roble75223022roble
rogue66417532rogue
role45851822role
rule49938422rule
sale44959702sale
socle7419572socle
sole46053672sole
tale46154162tale
tele45040872tele
tile45451442tile
togae67020112togae
toggle83810872toggle
togue64816302togue
toile54626492toile
tole46052902tole
tule45735872tule
ugly86012382ugly
vale74937342vale
vile76139802vile
vogie95116662vogie
vogue95613042vogue
voile84719722voile
vole75236982vole
wale74546432wale
wile75944372wile
wyle105519382wyle
yodle94515042yodle
yogee9518062yogee
yule75725142yule

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.0762351197.4
2DLD Change Limit298721501.42320992.3
3Display Results1501500.0602500.0
 (SQL Overall)1786911501.559114619.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.