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

112 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
yogi8612042(None) 
yagi86922241yagi
yoga87418051yoga
yogh116616141yogh
yogic116114931yogic
yogin98317741yogin
yogis95617741yogis
yoni77524391yoni
bog67852412bog_
bogie89524102bogie
bogs75742752bogs
bogy106426192bogy
cog69552902cog_
cogs77340032cogs
coni65534802coni
corgi8316082corgi
dog57449752dog_
doge66233802doge
dogie75222792dogie
dogs66440152dogs
dogy96126492dogy
foci94521012foci
fog76945562fog_
fogie96719002fogie
fogs87035002fogs
fogy115923182fogy
gogo69722832gogo
hog78049062hog_
hogg96617532hogg
hogs87139662hogs
hongi96715852hongi
jog117438312jog_
jogs127129332jogs
koi77534742ko_i
koji155611112koji
loci66126282loci
log46252682log_
loge56837192loge
logia68116602logia
logic88217832logic
login66025002login
logo57931762logo
logoi69715942logoi
logs57343112logs
logy87025782logy
loti46431832loti
magi76329522magi
modi76826312modi
mog66949672mog_
mogs75439332mogs
momi87524482momi
nodi56626742nodi
nog46847312nog_
nogg65115942nogg
nogs56534612nogs
nori47133142nori
obi57127722_obi
oi29061482_o_i
pogy105623552pogy
poi57244662po_i
ragi56032282ragi
roti46332922roti
shogi95013992shogi
soli46637002soli
sori46039832sori
tog410255042tog_
toga57027412toga
togs57242432togs
topi67830392topi
tori47542152tori
vagi86719362vagi
vogie95116662vogie
wog76242732wog_
wogs86531402wogs
yag76947732yag_
yagis95416572yagis
yags86632292yags
yegg96511792yegg
yeti75823212yeti
yo59748552yo__
yob87945272yo_b
yobs96028082yobs
yock135924612yock
yod77545502yo_d
yodh119916102yodh
yods86531182yods
yogas96615602yogas
yogee9518062yogee
yoghs125410592yoghs
yogini10449142yogini
yogins105114102yogins
yok107335242yo_k
yoke115626392yoke
yoks116223742yoks
yolk116218992yolk
yom88043442yo_m
yomim12510072yomim
yon67348952yo_n
yond86122312yond
yonic105920842yonic
yonis85020822yonis
yore76335942yore
you66641822yo_u
your78623432your
yous76230652yous
yow96945292yo_w
yowe106728742yowe
yowie114616452yowie
yowl105820952yowl
yows106433122yows
yuga85615422yuga
zori137722922zori

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.1101624463.6
2DLD Change Limit298721120.86034734.9
3Display Results1121120.0303733.3
 (SQL Overall)1786911121.000178691.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.