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

43 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
plastrums134451(None) 
plastrum1245711plastrum_
lustrums1044662_lustrums
plastrons1147132plastrons
plectrums1553032plectrums
alarums9408923ala__rums
antrums969173__antrums
asarums9467613__asarums
claustrum1352303claustrum_
colostrums14103103colostrums
diestrums1244413diestrums
electrums1344483electrums
estrums9208603__estrums
labarums1254503_labarums
labrums1175853_la_brums
larums83610533_la__rums
lustrum945853_lustrum_
nostrums1045683_nostrums
oestrums10156473_oestrums
pantoums1236713p_antoums
pasteups1243493p_asteups
pastoriums1445553p_astoriums
pastrami1246333p_astrami
pastramis1345683p_astramis
pastries101517423p_astries
pastromi1256353p_astromi
pastromis1346583p_astromis
pastures10311963p_astures
piastres10249303piastr_es
plasms103711333plas___ms
plasterers1286123plasterers
plasters103518133plast_ers
plastics122412333plast_ics
plastids11269213plast_ids
plastiques2142813plastiques
plastral1046913plastr_al
plastron1046913plastr_on
platinums1343963platinums
plectrum1453953plectrum_
rostrums1046083_rostrums
sistrums1055313_sistrums
strums84716453___strums
tantrums1045113_tantrums

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 Filter1786911486410.423422437.4
2DLD Change Limit148641437.62619491.3
3Display Results43430.0133307.7
 (SQL Overall)178691438.06222164.6
 
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.