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

149 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
ogre5632074(None) 
gore55744961gore
ogee57629881ogee
ogle56325051ogle
ogres65818631ogres
ore36661831o_re
acre67330772acre
age47154332ag_e
agee56241492agee
ager55935842ager
agree65226032agree
ague55725922ague
are37874572_are
bare65460522bare
bogie89524102bogie
bogle85821682bogle
bore66051332bore
byre95023852byre
care66968372care
cere66741472cere
cire65836372cire
core67263112core
cure66149122cure
dare55848862dare
dere56845902dere
dire56644142dire
doge66233802dog_e
dogie75222792dogie
dore56353302dore
dure56341812dure
eagre64315322eagre
eger55923562eger
egret63327312egret
ere36352772_ere
eyre75525252eyre
fare76354462fare
fere76342232fere
fire76245592fire
fogie96719002fogie
fore78351472fore
forge95126942forge
gae46457702_gae
gee45359202_gee
gie47149542_gie
goer56827102goer
gone55639042gone
gor47848262gor_
gored75227082gored
gores65740372gores
gorge76423892gorge
gorm75529392gorm
gorp75625902gorp
gorse65926812gorse
gory86129662gory
gree56641562_gree
grew85620262_grew
grey85624042_grey
grue55825712_grue
gyre84722762gyre
hare76255732hare
here76447102here
hire75538962hire
ire36943172_ire
kore85834162kore
lire47845292lire
loge56837192log_e
lore45850352lore
lure45142462lure
lyre75623792lyre
mare64759322mare
mere67244442mere
mire66748232mire
moire71017322moire
more67154522more
mure65941332mure
oar37057952oar_
oared65030652oared
oars46846032oars
obe56638642o_be
oboe66822942oboe
ochre103411592ochre
ocrea73311822ocrea
ode47446582o_de
oe28473062o__e
ogam75120032ogam
ogees65119142ogees
ogive9379092ogive
ogled75915962ogled
ogler65917442ogler
ogles65223182ogles
ogress7529502ogress
oke75839482o_ke
okra86413572okra
ole37155212o_le
ombre94111802ombre
omer67028392omer
once65423082once
one37050912o_ne
oorie53026362oorie
ooze136420602ooze
ope56845242o_pe
or27354732o_r_
ora37250832o_ra
orb55736862o_rb
orc57034922o_rc
ores46056682o_res
orgy85218002orgy
orle45630462orle
orra46120722orra
ors35750112o_rs
ort39465232o_rt
ose38147342o_se
our36042892our_
ourie54027292ourie
ours47237562ours
outre53922192outre
over77227342over
owe67041032o_we
owse76321622owse
oyer75927652oyer
pare66760842pare
pere66450262pere
pore66451262pore
pure65543332pure
pyre94925552pyre
rare45348432rare
re26153742__re
roger64521412roger
rogue66417532rogue
sere46153472sere
sire46150412sire
sore47059532sore
sure45447412sure
tare45957622tare
tire46143352tire
togae67020112togae
togue64816302togue
tore47359322tore
tyre75428252tyre
urge54722412urge
vogie95116662vogie
vogue95613042vogue
ware76254722ware
were76238332were
wire75839812wire
wore77144672wore
yare75636942yare
yogee9518062yogee
yore76335942yore

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 Limit298721490.90632971.3
3Display Results1491490.0463239.1
 (SQL Overall)1786911491.028173823.9
 
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.