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

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

66 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
plasms10371133(None) 
plasm94114631plasm_
plasma103810911plasma
plasmas113010751plasmas
alarms85913052alarms
blams95023852bla_ms
blasts85116772blasts
chasms135513142chasms
claims105211572claims
clams95127672cla_ms
clasps104512092clasps
class75525482clas_s
clasts84817292clasts
flams105125012fla_ms
flasks13488672flasks
glams85822932gla_ms
glass65518132glas_s
lams66552262_la_ms
lases54944762_lases
lass47444542_las_s
lasts57731262_lasts
miasms1097382miasms
palms94921752p_alms
pams85641762p_a_ms
pases75346502p_ases
pass65239952p_as_s
pasts75936502p_asts
peases85229472peases
phases114618402phases
phasis114614922phasis
places104323702places
placks144414152placks
plages94520152plages
plaids94312442plaids
plains85019592plains
plaits83816472plaits
planes85028082planes
planks124116752planks
plans75731272pla_ns
plants84921802plants
plash104616562plas_h
plashes124417392plashes
plashy14448872plashy
plasmic13249112plasmic
plasmid12239552plasmid
plasmids13236552plasmids
plasmin112410032plasmin
plasmins12199402plasmins
plasmon11257982plasmon
plasmons12217662plasmons
plates85432242plates
plats75531372pla_ts
platys11459852platys
playas114612282playas
plays106320772pla_ys
plazas17409912plazas
pleases94515482pleases
plums94619952pl_ums
pluses83618072pluses
praams10459642praams
prams96125512pra_ms
prases84429022prases
prisms104915502prisms
psalms1045672psalms
slams74927902sla_ms
spasms10418972spasms

Search took 6 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 Filter178691825510.1261418182.5
2DLD Change Limit82551665.51614965.7
3Display Results66660.0135076.9
 (SQL Overall)178691665.65531598.8
 
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.