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

123 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
plasterer117811(None) 
plastered1288901plastered
plasterers1286121plasterers
blusterer11176292blusterer
clatterer11186992clatterer
flatterer12187682flatterer
palterer102411282p_alterer
pasturer1037522p_asturer
patterer103112172p_atterer
pesterer102412712p_esterer
plaistered1344132plaistered
plaster93318692plast__er
plasters103518132plaster_s
plastery13279702plaster_y
alterer72714003__alterer
austerer838383_austerer
banterer102811773_banterer
barterer102711633_barterer
batterer102713213_batterer
blaster94017303blast__er
blasters104116143blaster_s
blastier10249493blast_ier
blatherer14176723blatherer
blattered12198573blattered
blistered12167683blistered
blustered12157263blustered
blusterers12174993blusterers
bolsterer1145483bolsterer
caterer92815943_ca_terer
charterer14197323charterer
chastener1445703chastener
chatterer14196843chatterer
clamberer15185273clamberer
clattered12178413clattered
clatterers12155423clatterers
clustered12186613clustered
easterner945053_easterner
elastomer1144943elastomer
falterer11239863_falterer
fastener11227833_fastener
flattener12175173flattener
flattered13188633flattered
flatterers13175913flatterers
flustered13185883flustered
flutterer12185263flutterer
fosterer11239523_fosterer
glistered11176303glistered
hastener11259133_hastener
laster64830633_last__er
lasters75627693_laster_s
latherer111310453_latherer
letterer8259223_letterer
listener8158313_listener
litterer82810173_litterer
lobsterer1144033lobsterer
loiterer837083_loiterer
lustered92510603_lustered
mastered112614003_mastered
oysterer1136103_oysterer
palaverer1443173palaverer
paltered113012493p_altered
palterers11249533p_alterers
pamperer14228333p_amperer
panderer112210913p_anderer
paperer113111903p_a_perer
parterre1036993p_arterre
paster85734373p_ast__er
pastern94415063p_aster_n
pasterns104112623p_asterns
pasters94531733p_aster_s
pastier94320383p_ast_ier
pastored1139973p_astored
pasture9311463p_asture_
pastured1138233p_astured
pasturers1136393p_asturers
pastures10311963p_astures
pattered112714203p_attered
patterers112410123p_atterers
pestered112814973p_estered
pesterers112510463p_esterers
pewterer13256313p_ewterer
piaster93012883piast__er
piasters102912813piaster_s
piastre9307893piast_re_
piastres10249303piast_res
pilaster1038163pilast__er
pilasters1138223pilaster_s
plaister1068013plaist__er
plaisters1137813plaister_s
plaiter93615393plait__er
plaiters103512633plaiter_s
planter94017803plant__er
planters102915323planter_s
plasher124215033plas__her
plashers133813453plasher_s
plashier1337613plas_hier
plastering1339243plastering
plasterwork2051903plasterwork
plastral1046913plast_ral
plastron1046913plast_ron
plastrum1245713plast_rum
platelet10510733pla_telet
plater84427693pla_t__er
platers93924093pla_ter_s
platier93716293pla_t_ier
platter93917413pla_t_ter
platters103415283platter_s
plunderer1243753plunderer
posturer1038923p_osturer
potterer102310263p_otterer
poulterer1145423poulterer
putterer10209913p_utterer
quarterer18145713quarterer
replastered1442483replastered
roisterer946433roisterer
scatterer11186293scatterer
shatterer12177203shatterer
slanderer1046673slanderer
slaverer11196993sla_verer
smatterer11185813smatterer
splattered13163943splattered
splutterer12132743splutterer
waterer103314073_wa_terer

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 Limit1486411236.84321721.6
3Display Results1231230.0631952.4
 (SQL Overall)1786911237.32624391.3
 
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.