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

102 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
phasmid1526760(None) 
phasmids16195171phasmids
plasmid12239551plasmid
chasmed154710172chasmed
chasmic16177982chasmic
phased124011972phas_ed
phasic133612052phas_ic
phasis114614922phas_is
plasmic13249112plasmic
plasmids13236552plasmids
plasmin112410032plasmin
plasmoid1345582plasmoid
plastid102112522plastid
agamid103710673aga_mid
amid77036343__a_mid
aphasia122510873aphas_ia
aphasic142810063aphas_ic
aramid93315603ara_mid
chalcid1537873chalcid
chammied18215963chammied
charmed154714243charmed
chased125019293chas_ed
chasm125518793chasm__
chasmal14158213chasmal
chasms135513143chasm_s
chasmy16468543chasm_y
chassed134712133chassed
chassis123910663chassis
chiasmi14365573chiasmi_
chiasmic17295013chiasmic
cosmid11810643_cosmid
desmid1048363_desmid
dharmic1535013dharmic
haemic133210083_haemic
haemin113412663_haemin
haemoid1337193_haemoid
halid94424973_ha_lid
haloid104317753_haloid
hammed144116973_hammed
harmed125218833_harmed
harmin113117393_harmin
hashed136021943_hashed
hasped125014443_hasped
hasted105125283_hasted
hispid1238173_hispid
humid114213763_h_umid
jasmin1538073_jasmin
jassid1467223_jassid
khamsin1643973khamsin
masjid16187313_masjid
miasmic1335743miasmic
paid75737483p_a__id
pallid93915273p_allid
palmed114314643p_almed
pashed125923143p_ashed
passed94320943p_assed
passim10410283p_assim
pasted94426903p_asted
pastie85525523p_astie
pastil85018323p_astil
pastis84924323p_astis
pavid115717003p_a_vid
peascod1244073peascod
phalli1148263phalli_
phallic1447293phallic
pharming16248143pharming
phase104617213phas__e
phaseal1245673phaseal
phases114618403phas_es
phasing133211673phasing
phatic133014403pha_tic
phosphid1985603phosphid
phrased1387383phras_ed
physed15386793phys_ed
physic16288473phys_ic
physis14359663phys_is
phytoid1678733phytoid
placid114012543pla_cid
placoid1239763placoid
plaid85118303pla__id
plashed133712643plashed
plasm94114633plasm__
plasma103810913plasm_a
plasmas113010753plasmas
plasmins12199403plasmins
plasmoids1444543plasmoids
plasmon11257983plasmon
plasms103711333plasm_s
plastic112815063plastic
plastids11269203plastids
prismoid1344983prismoid
psalmed1234503psalmed
psalmic1345333psalmic
pyaemia1445733pyaemia
pyaemic1645873pyaemic
pyramid1547503pyramid
shamed125120213sha_med
shammed153911423shammed
shammied16265543shammied
shaslik1444503shaslik
spasmed12296993spasmed
whammed18345133whammed

Search took 9 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.1561145455.1
2DLD Change Limit1340271028.04616657.6
3Display Results1021020.0462217.4
 (SQL Overall)1786911028.24821664.8
 
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.