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

145 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
oosperm113488(None) 
oosperms1243791oosperms
zoosperm2142931zoosperm
oosphere1355992oosphere
oospore939012oospore
sperm93216022__sperm
zoosperms2242612zoosperms
asper75520433_asper_
aspers86220313_aspers
booster94314553booster_
boosters104013453boosters
bopper123813833bopper_
boppers133911923boppers
bosker123813653bosker_
compere134616623compere
cooper104221123cooper_
coopers114019483coopers
coopery143910273coopery
coper95336093co_per_
copers104629843co_pers
copper124321893copper_
coppers133519753coppers
coppery16409393coppery
cosher114819903cosher_
coshers123618183coshers
cosier84423763cosier_
coster84331293coster_
costers94128343costers
deperm1139363_deperm
doper86128393do_per_
dopers95522483do_pers
dorper94314573dorper_
dorpers104113173dorpers
doser66228563dos_er_
dosers75723633dos_ers
dosser74417973dosser_
dossers84516233dossers
endosperm1443883endosperm
foppery17385623foppery
foster94322223foster_
fosters104220103fosters
gasper94515543gasper_
gaspers105014133gaspers
goosier83512563goosier_
gospel936533gospe_l
gospels1035593gospels
gosport101010283gosport
hooper114518313hooper_
hoopers123616493hoopers
hoper105829143ho_per_
hopers114222973ho_pers
hopper134218483hopper_
hoppers143115143hoppers
hoser811529763hos_er_
hosers95223973hos_ers
hosier94219613hosier_
hosiers104212643hosiers
hosiery13337183hosiery
jasper154610383jasper_
jaspers164310463jaspers
jaspery19405253jaspery
josher164312963josher_
joshers174111593joshers
kosher134412973kosher_
koshers144811803koshers
lisper84114433lisper_
lispers94514323lispers
looper83817113looper_
loopers93914033loopers
looser65219943loos_er_
loper75129233lo_per_
lopers84424143lo_pers
lopper103717203lopper_
loppers113014103loppers
loser54728673los_er_
losers65123583los_ers
misterm114314513misterm
moper94925923mo_per_
mopers104220373mo_pers
mopery135210973mo_pery
mopper126215003mopper_
moppers133412463moppers
mosher114719793mosher_
moshers124017843moshers
mosser84618273mosser_
mossers94116193mossers
nooser65517823noos_er_
noosers74913933noos_ers
noosphere1444773noosphere
nosher94616363nosher_
noshers103614333noshers
nosier63716333nosier_
oospheres1456633oospheres
oospores1049533oospores
oosporic1245063oosporic
oozier153610253oozier_
opera7313573_o_pera
osier53518013_osier_
osiers63412793_osiers
osprey1134883_osprey
ouster64223733ouster_
ousters74122793ousters
oyster94111703oyster_
oysters103411693oysters
perm85834633___perm
popery134511703po_pery
popper93615963popper_
poppers103414863poppers
poser75128773pos_er_
posers84223973pos_ers
posher115018163posher_
poster84129173poster_
postern93615613postern
posters93928013posters
prosper114012193prosper_
prospers123012263prospers
rasper83917333rasper_
raspers94415923raspers
romper104213683romper_
rompers113412243rompers
rooser63921883roos_er_
roosers74217883roos_ers
rooster74415173rooster_
roosters83514673roosters
roper75431913ro_per_
ropers84325903ro_pers
ropery114313873ro_pery
rosery93813283ros_ery
rosier64221273rosier_
roster64329083roster_
rosters73727553rosters
soaper84517873soaper_
soapers93715923soapers
sperms102512603__sperms
toper75231023to_per_
topers85025323to_pers
topper103817603topper_
toppers113914603toppers
tosser64215663tosser_
tossers74713503tossers
vesper1138083vesper_
vespers1239033vespers
zoospore1945633zoospore
zoster153715853zoster_
zosters163015413zosters

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271456.65620136.3
3Display Results1451450.0463152.2
 (SQL Overall)1786911457.09225196.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.