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

126 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
plasmid1223955(None) 
phasmid15267601phasmid
plasmic13249111plasmic
plasmids13236551plasmids
plasmin112410031plasmin
plasmoid1345581plasmoid
plastid102112521plastid
phasmids16195182phasmids
placid114012542pla_cid
placoid1239772placoid
plaid85118302pla__id
plashed133712642plashed
plasm94114632plasm__
plasma103810912plasm_a
plasmas113010752plasmas
plasmins12199402plasmins
plasmoids1444542plasmoids
plasmon11257982plasmon
plasms103711332plasm_s
plastic112815062plastic
plastids11269202plastids
agamid103710693aga_mid
alarmed1037733alarmed
amid77036353__a_mid
aplasia92510803aplas_ia
aplastic1249243aplastic
aramid93315613ara_mid
blamed116017953bla_med
blasted104213473blasted
blastie92411393blastie
chasmed154710173chasmed
chasmic16177983chasmic
claimed12298833claimed
clammed14369963clammed
clashed133614013clashed
clasped123610443clasped
classed104113653classed
classic113710113classic
classis93712723classis
clastic113013963clastic
cosmid11810643_cosmid
desmid1048363_desmid
elapid939543ela_pid
elastic93013393elastic
elastin72611843elastin
flaccid1544393flaccid
flamed124618973fla_med
flammed15377413flammed
flashed144112183flashed
glassed93710433glassed
glassie8329493glassie
jasmin1538073_jasmin
jassid1467223_jassid
laid56439143_la__id
lamed85235293_la_med
lamia75324323_la_mia
lammed113915623_lammed
lased65132343_las_ed
lashed105625213_lashed
lassi56316853_lassi_
lassie64917743_lassie
lassis65216703_lassis
lasted74323603_lasted
masjid16187323_masjid
miasmic1335743miasmic
paid75737483p_a__id
pallid93915283p_allid
palmed114314643p_almed
palship1446833palship
palsied102911303palsied
pashed125923143p_ashed
passed94320943p_assed
passim10410283p_assim
pasted94426903p_asted
pastie85525523p_astie
pastil85018323p_astil
pastis84924323p_astis
pavid115717003p_a_vid
peascod1244073peascod
phased124011973phas_ed
phasic133612053phas_ic
phasis114614923phas_is
placard1236783placard
placed114318003pla_ced
placoids1347343placoids
plafond1344183plafond
plagued11307473plagued
plaided11409643plaided
plaids94312443pla__ids
plain74823303pla__in
plained103812233plained
plait75631573pla__it
plaited103713893plaited
planed94420913pla_ned
planked143512283planked
planned103810153planned
planted103516123planted
plash104616563plas__h
plasher124215033plasher
plashes124417393plashes
plashier1337613plashier
plashing143311063plashing
plashy14448873plas_hy
plasmatic1547213plasmatic
plasmodia1453623plasmodia
plasmons12217663plasmons
plaster93318693plaster
plastics122412323plastics
plated95225773pla_ted
platted103614263platted
plaudit1046253plaudit
played124815033pla_yed
playsuit1343773playsuit
pleased103712073pleas_ed
pliskie1394543pliskie
plumed114412883pl_umed
prismoid1344983prismoid
psalmed1234503psalmed
psalmic1345333psalmic
pyaemia1445733pyaemia
pyaemic1645873pyaemic
pyramid1547513pyramid
slammed123511103slammed
slashed114114853slashed
spasmed12296993spasmed
splashed1435593splashed

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271266.04622167.9
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.23228673.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.