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

165 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
filterer1125814(None) 
falterer11239851falterer
filtered12259041filtered
filterers12206971filterers
alterer72713992_alterer
bitterer10309772bitterer
faltered122810982faltered
falterers12238032falterers
fetterer11207812fetterer
filter94517632filt__er
filters103816552filter_s
filthier1434072filthier
fingerer12127222fingerer
fosterer11239522fosterer
fritterer12234402fritterer
litterer82810172litterer
miterer92511332mi_terer
palterer102411272palterer
pilferer1344922pilferer
silverer11216732silverer
titterer8268522titterer
winterer112110442winterer
adulterer1043553adulterer
altered83215733_altered
alterers82512493_alterers
austerer838383austerer
banterer102811773banterer
barterer102711633barterer
batterer102713213batterer
bickerer16106773bickerer
billeter1037563billeter
bistered112913333bistered
bittered112711833bittered
bolsterer1145483bolsterer
caterer92815943_caterer
cipherer1545573cipherer
ditherer12187763ditherer
enterer72015633_enterer
falter94519053falt__er
falters103916473falter_s
fastener11227833fastener
fattener11268113fattener
festered122512113festered
fettered12259493fettered
fetterers12267043fetterers
fibered1337643fi_bered
fidgeter1343783fidgeter
fiercer12356953fi__ercer
fierier103511193fi__erier
fifteen1343923fifte_en
figurer11215863fi_gurer
filagree1295173filagree
filaree10611213fil_aree
filarees1187643filarees
filature1145423filature_
filatures1245853filatures
filbert12411643filber_t
filberts1334993filberts
filcher15377793fil_cher
filer85433003fil___er
filers94623723fil_er_s
fileted1159093fil_eted
filigree1264663filigree
filister1137403filister
filler94623623fil__ler
fillers104320213filler_s
filleted1236603filleted
filmer114112403fil__mer
filmers124211293filmer_s
filmgoer1442013filmgoer
filmier1237503fil_mier
filtering13199723filtering
fingered13128333fingered
fingerers13136303fingerers
firer811229253fi___rer
fitter94120033fi_t_ter
fitters104517753fitter_s
fixture1734963fixture_
fixtures1835283fixtures
flatterer12187673flatterer
fleecer12368033f_leecer
fleer86020773f_l_e_er
fleered11309503f_leered
fleeter103210363f_leeter
flitter103413903flit_ter
flittered13196253flittered
floorer10248073f_loorer
flowerer1435453flowerer
flutterer12185263flutterer
fostered122210453fostered
fosterers12238023fosterers
frittered13205163frittered
fritterers13203393fritterers
fruiterer1243333fruiterer
fullered1236383fullered
furtherer1543813furtherer
haltere103614703haltere_
haltered123112553haltered
halteres113414593halteres
hinderer1238273hinderer
integer837993_integer
jilter133512513jilt__er
jilters144211963jilter_s
jittered16267223jittered
jitterier1644433jitterier
kilter103714343kilt__er
kilters113813603kilter_s
kipperer16294723kipperer
letterer8259223letterer
limberer12187053limberer
lingerer9118303lingerer
listener8158313listener
littered92511383littered
litterers9228193litterers
loiterer837083loiterer
milter84921233milt__er
milters93619093milter_s
miltier93214963milt_ier
mitered103213233mi_tered
miterers10219683mi_terers
mutterer10218913mutterer
oysterer1136103oysterer
paltered113012483paltered
palterers11249533palterers
patterer103112173patterer
peltered112510453peltered
pesterer102412713pesterer
pewterer13256313pewterer
philtered1545493philtered
pilfered1435853pilfered
pilferers1444583pilferers
pilsener1044753pilsener
potterer102310263potterer
poulterer1145423poulterer
putterer10209913putterer
refiltered1443773refiltered
roisterer946433roisterer
shelterer1245033shelterer
siltier73413863silt_ier
silvered12237563silvered
silverers12215753silverers
simperer1237173simperer
sincerer1037203sincerer
sintered92213903sintered
sistered92612803sistered
sliverer11237633sliverer
solderer947183solderer
tillered937443tillered
tilter63417693tilt__er
tilters73315953tilter_s
tiltmeter1144343tiltmeter
tinkerer1286803tinkerer
tittered9239493tittered
titterers9236993titterers
totterer8217793totterer
twitterer1243303twitterer
unfiltered1443563unfiltered
utterer71910463_utterer
waterer103314073_waterer
weltered12238433weltered
wildered1336633wildered
wintered122111573wintered
winterers12209723winterers
winterier1238333winterier
witherer14187953witherer

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621656.61022112.3
3Display Results1651650.0602750.0
 (SQL Overall)1786911657.07625253.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.