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

39 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
pleustons114428(None) 
pleuston1044191pleuston_
neustons836832_neustons
pleustonic1452792pleustonic
plutons938342pl_u_tons
aleurons867013aleu_rons
allusions946013allusions
blousons1054403blous_ons
bluestone1144863bluestone
bluestones1244643bluestones
delusions1037053delusions
elusions82610083el_usions
fleurons1155343fleu_rons
gluttons944273gl_uttons
illusions946213illusions
leptons91910433_le_ptons
lesions73813873_le_sions
lessons73811023_le_ssons
leukons1135753_leu_kons
neuston736083_neuston_
pelotons1038913p_elotons
pensions10311693p_ensions
persons93717013p_ers_ons
pestos84719083p_e_sto_s
pistons93016373p__istons
planktons1543673planktons
plasmons12217663pl_asmons
plastrons1147133pl_astrons
plectrons13258073plectrons
pleons84213343ple___ons
plessors10278253ple_ssors
pleuron976343pleu_ron_
plosions1038023pl_osions
pluton838853pl_u_ton_
prelusions1256373prelusions
prestos93716083pre_sto_s
preunions1146483preunions
putons83515153p__u_tons
testons7313563_te_stons

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 Limit148641396.98621277.0
3Display Results39390.0133000.0
 (SQL Overall)178691397.41924085.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.