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

140 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
falterers1223803(None) 
alterers82512491_alterers
falterer11239861falterer_
filterers12206971filterers
palterers11249531palterers
alterer72714002_alterer_
banterers112410002banterers
barterers11269632barterers
batterers113110712batterers
caterers102814402ca_terers
faltered122810992faltere_d
falters103916472falt__ers
fasteners12237052fasteners
fatteners12236872fatteners
fetterers12267042fetterers
filterer11258142filterer_
flatterers13175912flatterers
fosterers12238022fosterers
halteres113414602haltere_s
palterer102411282palterer_
patterers112410122patterers
waterers112312782wa_terers
adherers1296923_adherers
adulterers1143173adulterers
alieners889823_alieners
allegers9378233_allegers
allurers8286773_allurers
altered83215743_altere_d
alters64924223_alt__ers
banterer102811773banterer_
barterer102711633barterer_
batteners11238163batteners
batterer102713213batterer_
blatherers15175343blatherers
bolsterers1244683bolsterers
caperers122611723ca_perers
capturers1344633capturers
careerers1137243careerers
caterer92815943ca_terer_
cateress102311613ca_teress
charterers15146053charterers
chatterers15205463chatterers
clatterers12155423clatterers
easterners1044823easterners
enterers82214153_enterers
factures13129033facture_s
fakeers14446673fa_ke_ers
falconers1445323falconers
falderals13104043falderals
falderols13103883falderols
fallers103917993fal__lers
falseness1236093falseness
falter94519053falt__er_
faltering132211113faltering
farers95924053fa___rers
fastener11227833fastener_
fathers133916503fa_t_hers
fattener11268113fattener_
favorers1465493fa_vorers
favourers1543123favourers
fetterer11207813fetterer_
filtered12259043filtere_d
filters103816553filt__ers
fingerers13136303fingerers
flatteners13164153flatteners
flatterer12187683flatterer_
flatters113814203flat_ters
flavorers1563983flavorers
fleecers13325933f_leecers
fleers96015793f_l_e_ers
floorers11227573f_loorers
flowerers1544503flowerers
flutterers13184593flutterers
fosterer11239523fosterer_
fracturers15123213fracturers
fritterers13203393fritterers
fruiterers1343003fruiterers
furtherers1643323furtherers
galeres83514343gal_ere_s
gatherers13156883gatherers
haltere103614713haltere__
haltered123112563haltere_d
halters104619803halt__ers
hammerers16216563hammerers
hamperers16287533hamperers
hankerers16226713hankerers
hasteners12267813hasteners
jabberers2043553jabberers
latherers12158853latherers
letterers9228113letterers
litterers9228193litterers
loiterers936263loiterers
maltsters1135193maltsters
maturers1037383ma_turers
miterers10219683_miterers
mutterers11247373mutterers
oysterers1245573oysterers
palaverers1542713palaverers
paltered113012493paltere_d
palters94021683palt__ers
pamperers15236863pamperers
panderers12229153panderers
paperers122410453pa_perers
parterres1148063parterres
pasturers1136393pasturers
patterer103112173patterer_
pesterers112510463pesterers
pewterers14216043pewterers
pilferers1444583pilferers
plasterers1286123plasterers
potterers11218663potterers
poulterers1244563poulterers
putterers11238363putterers
quarterers19124823quarterers
ratteners9237263ratteners
salterns8388903salter_ns
salters73622253salt__ers
saltiers83411953salt_iers
saltires83112433saltire_s
saltpeters1253093saltpeters
saunterers1044383saunterers
scatterers12205043scatterers
shatterers13185723shatterers
shelterers1344343shelterers
silverers12215753silverers
slaverers12165993slaverers
smatterers12174873smatterers
solderers1066533solderers
tamperers13227313tamperers
taperers10269773ta_perers
titterers9236993titterers
totterers9186813totterers
utterers8218653_utterers
wagerers12247613wa_gerers
waltzers2034003walt_zers
wanderers13228483wanderers
waterer103314073wa_terer_
waverers14318613wa_verers
winterers12209723winterers
yammerers16214453yammerers

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.423422437.4
2DLD Change Limit1486411407.37620152.0
3Display Results1401400.0602333.3
 (SQL Overall)1786911407.85922737.1
 
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.