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 “osprey” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

236 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
osprey113488(None) 
ospreys1233141ospreys
kouprey1652792kouprey
orphrey15133392orphrey
prey96228482__prey
spray106720062_spray
spree74830862_spree
spry96819122_spr_y
apery106517903_apery
apres75426403_apres
aspen75216093asp_en
asper75520433asp_er
aspers86220313aspers
aspire8612123aspire_
aspired1068173aspired
aspirer967903aspirer
aspires9612043aspires
astray95615543astray
comfrey1734683comfrey
coopery143910273coopery
coppery16409393coppery
cosey106226713cos__ey
costrel9310363costrel
cypres1338523cypres
dopey116020353dop_ey
dupery12378743dupery
empery1348683empery
espied9359773espied
espies83716803espies
esprit8312843esprit
espy969373esp__y
estray95713333estray
foppery17385623foppery
gospel936533gosp_el
grey85624043__grey
hosey116127023hos__ey
hosiery13337183hosiery
japery18439143japery
jaspery19405253jaspery
koupreys1741733koupreys
lamprey1434863lamprey
mopery135210973mopery
mopey124821823mop_ey
mosey105922873mos__ey
murrey114312253murrey
napery11489813napery
nosey85619883nos__ey
oared65030653o_ared
obey96521303o__bey
ochery14319443ochery
ochre103411593ochre_
ochrea11316643ochrea
ochred12328003ochred
ochres113510833ochres
ochry13346933ochr_y
ocrea73311823o_crea
odored8399223odored
offkey1932343offkey
ogre56320743o_gre_
ogres65818633o_gres
ombre94111803ombre_
ombres103911143ombres
onery8414123oner_y
oosperm1134883oosperm
oospore939013oospore_
oospores1049523oospores
ope56845243o_p_e_
oped76230153o_p_ed
open66427003o_p_en
opera7313573o_pera
opes65942613o_p_es
oppress1135993oppress
opted84914273o_pted
orby97519603o__rby
ore36661833o__re_
ores46056683o__res
orfray1234393orfray
orgy85218003o__rgy
ornery938463ornery
orphreys16132053orphreys
orrery936783o_rrery
osar46820953osar__
ose38147343os__e_
oses46641513os__es
osier53518013os_ier
osiered837123osiered
osiers63412793osiers
ossify1244973ossify
ostler63312193ostler
ostomy1137823ostomy
ouphe104413263ouphe_
ouphes113614633ouphes
outpray12268083outpray
outre53922193outre_
ovary1149113ovar_y
overed102216623overed
overly122411363overly
papery134812743papery
popery134511703popery
pray96331533__pray
pree67044733__pree
prep86427673__prep
prex135722973__prex
prexy174611573__prexy
preys105717783__preys
prez156126313__prez
pry85728053__pr_y
respray1236503respray
ropery114313873ropery
ropey106021873rop_ey
rosary92810353rosar_y
rosery93813283roser_y
saree55044663_saree
sarky125521783_sarky
scarey115016983scarey
scree720031703_scree
screw109318533_screw
screwy14659453_screwy
scry96017763_scr_y
sere46153473_sere_
sered65737293_sered
serer55935503_serer
seres55448893_seres
serry84824123_serry
shred98125613_shred
shrew119720163_shrew
sire46150413_sire_
sired66134283_sired
siree55238813_siree
siren54525823_siren
sires55945373_sires
skiey125012893_skiey
skyey15537223_skyey
soared74324293soared
soarer64522243soarer
soiree62919483soiree
sooey84522433_sooey
sophy136611763sop_hy
sopped114819903sopped
soppy125113523sop_py
sore47059533_sore_
sored66141783_sored
sorel56231443_sorel
sorely94618003_sorely
sorer56236573_sorer
sores55454283_sores
sorrel6413543sorrel
sorry84618253_sorry
soured74921863soured
sourer63620213sourer
sourly93612203sourly
spacey136212533_spacey
spacy125415623_spacy
spae65034323_spae_
spaed85522273_spaed
spaes76029973_spaes
spare75135563_spare_
spared95427483_spared
sparely123410663_sparely
sparer84524963_sparer
spares84834553_spares
sparky154511523_sparky
sparry115111303_sparry
spay96631663_sp_ay
spec85821973_sp_ec
sped76031493_sp_ed
speed85526623_speed
speedy1218410783_speedy
speel74420763_speel
speer74623903_speer
sperm93216013_sperm
spew95421873_sp_ew
sphery14318883_sphery
spicey134414233_spicey
spicy125417713_spicy
spied85427713_spied
spiel74623913_spiel
spier75728033_spier
spies76037623_spies
spikey155411333_spikey
spiky146014113_spiky
spiny104921303_spiny
spire75828693_spire_
spirea84015633_spirea
spired94921863_spired
spirem104214163_spirem
spires84628113_spires
spiry105017353_spiry
splay105816043_splay
spore75428593_spore_
spored94821793_spored
spores84726613_spores
sporty115112493_sporty
sprag86418693_sprag
sprat76635973_sprat
sprays115913643_sprays
spread9312533_spread
sprees85620643_sprees
sprent84522383_sprent
sprier84119063_sprier
sprig85617743_sprig
sprit76736403_sprit
sprucy13356323_sprucy
sprue74717633_sprue
sprues84515763_sprues
sprug85313893_sprug
spryer11418533_spryer
spryly1435513_spryly
spue66025523_spue_
spued84918473_spued
spues75025383_spues
spumy124610363_spumy
spurrey12307803_spurrey
spurry11429113_spurry
spy86023743_sp__y
stey76224413_s_tey
storey95217613storey
stray88525573_stray
strep77120853_strep
strew89220653_strew
stroy87720393_stroy
sure45447413_sure_
surely93816453_surely
surer54833093_surer
surety93515003_surety
surfy115319473_surfy
surgy95118523_surgy
surly85124423_surly
surrey94414573surrey
survey124111663_survey
syren85216743_syren
trey77228793__trey
tsores65113663tsores
typey135511883typ_ey
usurer638103usurer
usury887623usur_y

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162366.65616934.5
3Display Results2362360.1561512.8
 (SQL Overall)1786912366.95225703.5
 
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.