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

108 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
filterers1220697(None) 
falterers12238031falterers
filterer11258141filterer_
alterers82512492_alterers
falterer11239852falterer_
fetterers12267042fetterers
filtered12259042filtere_d
filters103816552filt__ers
fingerers13136302fingerers
fosterers12238022fosterers
fritterers13203392fritterers
litterers9228192litterers
miterers10219682mi_terers
palterers11249532palterers
pilferers1444582pilferers
silverers12215752silverers
titterers9236992titterers
winterers12209722winterers
adulterers1143173adulterers
alterer72713993_alterer_
banterers112410003banterers
barterers11269633barterers
batterers113110713batterers
bickerers17115593bickerers
billeters1136873billeters
bitterer10309773bitterer_
bolsterers1244683bolsterers
caterers102814403_caterers
cipherers1644893cipherers
ditherers13196683ditherers
enterers82214153_enterers
faltered122810983faltere_d
falters103916473falt__ers
fasteners12237053fasteners
fatteners12236873fatteners
fetterer11207813fetterer_
fidgeters1443623fidgeters
fifteens1442753fifte_ens
figurers12254873fi_gurers
filagrees1373883filagrees
filarees1187643fil_arees
filatures1245853filature_s
filberts1334993filber_ts
filchers16286863fil_chers
filers94623723fil___ers
filigrees1383263filigrees
filisters1237003filisters
fillers104320213fil__lers
filmers124211293fil__mers
filmgoers1541983filmgoers
filter94517633filt__er_
filtering13199723filtering
filthier1434073filthier_
fingerer12127223fingerer_
firers94922683fi___rers
fitters104517753fi_t_ters
fixtures1835283fixture_s
flatterers13175913flatterers
fleecers13325933f_leecers
fleers96015793f_l_e_ers
flitters114312173flit_ters
floorers11227573f_loorers
flowerers1544503flowerers
flutterers13184593flutterers
fosterer11239523fosterer_
fritterer12234403fritterer_
fruiterers1343003fruiterers
furtherers1643323furtherers
halteres113414593haltere_s
hinderers1337353hinderers
integers937783_integers
jilters144211963jilt__ers
kilters113813603kilt__ers
kipperers17233823kipperers
letterers9228113letterers
lingerers10126923lingerers
listeners9147323listeners
litterer82810173litterer_
loiterers936263loiterers
milters93619093milt__ers
miterer92511333mi_terer_
mutterers11247373mutterers
oysterers1245573oysterers
palterer102411273palterer_
patterers112410123patterers
pesterers112510453pesterers
pewterers14216043pewterers
pilferer1344923pilferer_
pilseners1144943pilseners
potterers11218663potterers
poulterers1244563poulterers
putterers11238363putterers
roisterers1045113roisterers
shelterers1344343shelterers
silverer11216733silverer_
simperers1335933simperers
sliverers12196363sliverers
solderers1066533solderers
tilters73315953tilt__ers
tiltmeters1244123tiltmeters
tinkerers1395423tinkerers
titterer8268523titterer_
totterers9186813totterers
twitterers1342673twitterers
utterers8218653_utterers
waterers112312783_waterers
winterer112110443winterer_
witherers15146843witherers

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.436409841.7
2DLD Change Limit1486411086.93621430.4
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.41824088.8
 
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.