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

69 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
plastrons114713(None) 
plastron1046911plastron_
klystrons1642362klystrons
patrons93818102p_a_trons
plasmons12217662plas_mons
plastrums1344512plastrums
platoons1038682pla_toons
plectrons13258072plectrons
pliotrons1144712pliotrons
alastors8311223alast_ors
alations82518893ala_tions
bastions10411693_bastions
calutrons1145503calutrons
cistrons102710643_cistrons
classons1037703clas_sons
diatrons939623dia_trons
elastins82111743elast_ins
elations83719123ela_tions
electrons112411763electrons
flaperons14125043flaperons
flatirons1244483flatirons
gastrins9310133_gastrins
klystron1542523klystron_
ladrons83813193_la_drons
lastborns1143383_lastborns
lustrous877803_lustrous
matrons93517633_ma_trons
natrons73215663_na_trons
pactions122613503p_actions
partons94620513p_art_ons
passions10310583p_assions
pasterns104112623p_asterns
pastors94119003p_ast_ors
pastries101517423p_astries
pastromi1256353p_astromi
pastromis1346603p_astromis
patrols93513513p_a_trols
patron84018043p_a_tron_
patroons102710603p_a_troons
phaetons1345853phaet_ons
piastres10249303piastr_es
pistons93016373p_ist_ons
placations1438583placations
planations1238723planations
planktons1543673planktons
plantains1147493plantains
plasmins12199413plas_mins
plasmon11257983plas_mon_
plasterers1286123plasterers
plastering1339243plastering
plasterings1444743plasterings
plasters103518133plast_ers
plastics122412333plast_ics
plastids11269213plast_ids
plastisols1242353plastisols
plastral1046913plastr_al
plastrum1245713plastr_um
platans93413123pla_t_ans
platens94213983pla_t_ens
platoon938953pla_toon_
plectron12228023plectron_
pleustons1144283pleust_ons
pliotron1044563pliotron_
plosions1038023plos_ions
plutons938343pl_ut_ons
polarons1039863pola__rons
positrons1186543positrons
pulsations1236373pulsations
waitrons1136643_waitrons

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 Filter1786911486410.420425454.8
2DLD Change Limit148641697.22020587.4
3Display Results69690.0302300.0
 (SQL Overall)178691697.67023297.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.