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

250 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
filtered1225904(None) 
faltered122810991faltered
filterer11258141filterer
altered83215742_altered
bistered112913332bistered
bittered112711832bittered
falterer11239862falterer
festered122512112festered
fettered12259492fettered
fibered1337642fi_bered
fileted1159092fil_eted
filleted1236602filleted
filter94517632filter__
filterers12206972filterers
filters103816552filter_s
fingered13128332fingered
fleered11309502f_leered
flittered13196252flittered
fostered122210452fostered
frittered13205162frittered
fullered1236382fullered
haltered123112562haltered
jittered16267222jittered
littered92511382littered
mitered103213232mi_tered
paltered113012492paltered
peltered112510452peltered
philtered1545492philtered
pilfered1435852pilfered
refiltered1443772refiltered
silvered12237562silvered
sintered92213902sintered
sistered92612802sistered
tillered937442tillered
tittered9239492tittered
unfiltered1443562unfiltered
weltered12238432weltered
wildered1336632wildered
wintered122111572wintered
alterer72714003_alterer
antlered938263antlered
bantered113313633bantered
bartered113113013bartered
battered113315053battered
bettered113011843bettered
bickered17108003bickered
billeted1137643billeted
bistred103311853bist_red
bitterer10309773bitterer
blistered12167683blistered
blithered15156123blithered
bolstered1246093bolstered
buttered112712623buttered
cantered113415983cantered
catered103117773_catered
centered112513523centered
chittered15166413chittered
cindered1239793cindered
ciphered1637053ciphered
cottered112511733cottered
cratered1149683cratered
cultured1137233cultured
diapered1238003diapered
dickered16117533dickered
differed1635523differed
dithered13189293dithered
entered82718883_entered
factored1436233factored
falter94519053falter__
falterers12238033falterers
falters103916473falter_s
fastened12257853fastened
fathered151510433fathered
fattened12268283fattened
feathered16188893feathered
featured1237683featured
felted103714653felt__ed
fendered13258673fendered
fetterer11207813fetterer
fevered14339723f_evered
fidgeted1443893fidgeted
fifteen1343923fifte_en
figured12196473fi_gured
filagree1295173filagree
filagreed1472873filagreed
filaree10611213fil_aree
filarees1187643filarees
filature1145433filature_
filatures1245863filatures
filbert12411643filber_t
filberts1334993filberts
filched16307423fil_ched
filed95331903fil___ed
filer85433003fil_er__
filers94623723fil_er_s
filiated12610083filiated
filigree1264663filigree
filigreed1482443filigreed
filled104922263fil__led
filler94623623filler__
fillers104320213filler_s
filliped1435223filliped
filmed124610363fil__med
filmer114112403filmer__
filmers124211293filmer_s
filtering13199723filtering
filthier1434073filthier
filtrated1345963filtrated
fingerer12127223fingerer
fired94829743fi___red
fissured1235183fissured
fisted104218703fist__ed
fitted104716663fi_t_ted
fitter94120033fitter__
fitters104517753fitter_s
fixture1734963fixture_
fixtures1835283fixtures
flared105317603f_l_ared
flattered13188633flattered
fleeced13358153f_leeced
fleeted113310233f_leeted
flexed17419093f_l_exed
fleyed13408813f_l_eyed
flichtered1942133flichtered
flickered1943753flickered
flitched17256293flitched
flited104616583flit__ed
flitted114011643flit_ted
floored11268683f_loored
floured11289873f_loured
flowered1546013flowered
flustered13185883flustered
fluttered13185943fluttered
foddered1434553foddered
fosterer11239523fosterer
fritterer12234403fritterer
furthered1644473furthered
gartered10319593gartered
gettered10258613gettered
gibbered1444303gibbered
gingered11127743gingered
glistered11176303glistered
glittered11195413glittered
guttered10259163guttered
haltere103614713haltere_
halteres113414603halteres
hilted104016043hilt__ed
hindered1339453hindered
hollered1237603hollered
holstered1345883holstered
inhered11313163_inhered
interbed112413103_interbed
interned93016653_interned
interred92615263_interred
itemed936603_i_temed
jiggered1834203jiggered
jilted144111353jilt__ed
jilter133512513jilter__
jilters144211963jilter_s
kilted113613833kilt__ed
kilter103714343kilter__
kilters113813603kilter_s
kippered17255623kippered
kittened1334523kittened
leered73816223__leered
leistered1037043leistered
lettered92910783lettered
lightered1446283lightered
lilted73715373lilt__ed
limbered13158123limbered
lingered10129643lingered
lippered13287953lippered
listened9168813listened
litterer82810173litterer
livered113111633li_vered
loitered938183loitered
lustered92510603lustered
mastered112614003mastered
mattered112412903mattered
metered103514013_metered
mildened1235773mildened
mildewed1543763mildewed
milleped1335173milleped
milted93919943milt__ed
milter84921233milter__
milters93619093milter_s
misaltered1344563misaltered
mistermed1438363mistermed
miterer92511333mi_terer
mitred94414343mi_t_red
mittened1136363mittened
moldered1237173moldered
mustered112511503mustered
muttered112610793muttered
nattered92011623nattered
neutered937423neutered
nickered15117023nickered
niffered1544143niffered
oilseed835783oilse_ed
oystered1236923oystered
palterer102411283palterer
pattered112714203pattered
pestered112814973pestered
petered103314973_petered
philtred14114183philt_red
pictured1346573pictured
pilferer1344923pilferer
pillared11228093pillared
portered112311543portered
pottered112311663pottered
puttered112611143puttered
raftered1237663raftered
realtered1037893realtered
roistered1037643roistered
sheltered1335573sheltered
silted74020013silt__ed
silverer11216733silverer
simmered1336863simmered
simpered1338253simpered
skeltered1443873skeltered
skittered1434633skittered
slithered13136623slithered
slivered12218103slivered
soldered1038153soldered
sweltered1344453sweltered
tattered92011443tattered
teetered9258303teetered
telfered1234883telfered
tentered96412103tentered
tiered73613973ti__ered
tilted74616863tilt__ed
tilter63417693tilter__
tilters73315953tilter_s
timbered13137383timbered
tinkered1387683tinkered
titterer8268523titterer
tottered9208703tottered
twittered1333813twittered
ulcered1037973_ulcered
unaltered1037723unaltered
uttered82712433_uttered
waitered1238753waitered
watered113014953_watered
westered122511873westered
wilted103915713wilt__ed
winterer112110443winterer
winterfed1644993winterfed
withered15169433withered
yattered12239533yattered
zippered22244823zippered

Search took 7 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.403443402.0
2DLD Change Limit1461622506.23623438.4
3Display Results2502500.0932688.2
 (SQL Overall)1786912506.73226543.5
 
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.