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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
plasmids1323655(None) 
phasmids16195181phasmids
plasmid12239551plasmid_
plasmins12199411plasmins
plasmoids1444541plasmoids
plastids11269211plastids
phasmid15267602phasmid_
placoids1347342placoids
plaids94312442pla__ids
plasmas113010752plasm_as
plasmic13249112plasmi_c
plasmin112410032plasmi_n
plasmoid1345582plasmoid_
plasmons12217662plasmons
plasms103711332plasm__s
plastics122412332plastics
plastid102112522plastid_
agamids11317013aga_mids
amids85627513__a_mids
aplasias10279233aplas_ias
aramids102810513ara_mids
blasties102113633blasties
classics12418873classics
classis93712723classi_s
clastics122811413clastics
cosmids1237633_cosmids
desmids1166603_desmids
elapids1036503ela_pids
elastics102710883elastics
elastins82111743elastins
glassies94012273glassies
jasmins1637083_jasmins
jassids1586143_jassids
lameds94812033_la_meds
lamias85020613_la_mias
lashins103915153_lashins
lassies74420103_lassies
lassis65216703_lassi_s
masjids17175403_masjids
palships1546213palships
palsies94420273pals_ies
pasties94529813p_asties
pastils94416173p_astils
pastis84924323p_asti_s
peascods1344063peascods
phasis114614923phas_i_s
placards1345813placards
placid114012543pla_cid_
placoid1239773placoid_
plafonds1443273plafonds
plaid85118303pla__id_
plains85019593pla__ins
plaits83816473pla__its
plashed133712643plashed_
plashers133813453plashers
plashes124417393plas_hes
plashier1337613plashier
plashiest1478373plashiest
plashing143311063plashing
plasm94114633plasm___
plasma103810913plasm__a
plasmodesm1752663plasmodesm
plasmodia1453623plasmodia
plasmon11257983plasm_on
plasters103518133plasters
plastic112815063plasti_c
platies93722543pla_ties
plaudits1144263plaudits
playsuits1442653playsuits
pliskies1475973pliskies
prismoids1443613prismoids
pyaemias1545063pyaemias
pyramids1645643pyramids

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 Filter1786911461620.1731032896.0
2DLD Change Limit146162737.72018932.9
3Display Results73730.0135615.4
 (SQL Overall)178691737.90622601.9
 
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.