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

111 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
plessors1027825(None) 
lessors73610521_lessors
plessor9317691plessor_
pressors103212691pressors
blessers10277632blessers
colessors1145662colessors
lessons73811022_lessons
lessor64010602_lessor_
pleasers104010292pleasers
pledgors12325262pledgors
plexors1645422ple_xors
pressers103215022pressers
pressor93512882pressor_
alastors8311203alastors
assessors843933assessors
blesboks1643043blesboks
blesser9329293blesser_
blesses93812393bless_es
blossoms12134553blossoms
censors93611843_censors
classers104111833classers
classons1037703classons
colessor1045233colessor_
depressors1354903depressors
dressers9359863dressers
electors103013843electors
flensers1135463flensers
fleshers14339443fleshers
flexors1734773fle_xors
flossers11307863flossers
gessoes838293_gessoes
glossers9319053glossers
guessers9174903guessers
lassoers8338513_lassoers
lassoes74613853_lassoes
lassos64913813_lasso_s
leasers74717843_leasers
lectors93415763_lectors
lesbos837403_lesbo_s
lesions73813873_lesions
lessees73510243_lessees
lessens7409383_lessens
lesser63514853_lesser_
lesson64412043_lesso_n
nestors73614973_nestors
obsessors1142883obsessors
oppressors1463843oppressors
paleosols1143993paleosols
passers94717753p_assers
pastors94119003p_astors
persons93717013p_ersons
pesos77221623p_e_so_s
pessary1246873p_essary
pesters93827093p_esters
pestos84719083p_esto_s
pissers95014753p_issers
pissoirs1044693p_issoirs
plashers133813453plashers
plasmons12217663plasmons
plasters103518133plasters
pleaders113210183pleaders
pleaser93912343pleaser_
pleases94515483pleas_es
pleasure1045543pleasure
pleasures1145573pleasures
pleaters103613793pleaters
pledgeors13313083pledgeors
pledgers12387643pledgers
pledgor11334993pledgor_
pleons84213343ple__ons
pleopods1344443pleopods
plethora1344823plethora
plethoras1444803plethoras
pleustons1144283pleustons
plexor1535253ple_xor_
plimsols1242973plimsols
plisses94411773pliss_es
plosions1038023plosions
plusses93510693pluss_es
polestars1157283polestars
possessors1153193possessors
prescore124812373prescore
prescores133912173prescores
preshows16267023preshows
presort95219543pre_sort
presorts105311683pre_sorts
presser93717623presser_
presses93523153press_es
pressure1039773pressure
pressures1149063pressures
presswork1854533presswork
pressworks1954123pressworks
presters103419003presters
prestore104217353prestore
prestores114716083prestores
prestos93716083presto_s
pretors9316813pre_tors
previsors14126483previsors
processors1446433processors
professors1555253professors
questors17147013questors
repressors1265773repressors
scissors1054353scissors
seisors73212843_seisors
sensors73514643_sensors
splendors1244023splendors
stressors955793stressors
sublessors1243373sublessors
tensors72712373_tensors
tressours943893tressours
tussors7388773_tussors

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621117.65619091.2
3Display Results1111110.0462413.0
 (SQL Overall)1786911118.10822038.9
 
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.