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

194 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
falterer1123987(None) 
alterer72714011_alterer
faltered122811001faltered
falterers12238041falterers
filterer11258141filterer
palterer102411291palterer
altered83215752_altered
alterers82512502_alterers
banterer102811782banterer
barterer102711652barterer
batterer102713222batterer
caterer92815952ca_terer
falter94519052falt__er
falters103916472falter_s
fastener11227842fastener
fattener11268112fattener
fetterer11207812fetterer
filtered12259042filtered
filterers12206972filterers
flatterer12187682flatterer
fosterer11239522fosterer
haltere103614712haltere_
haltered123112572haltered
halteres113414602halteres
paltered113012502paltered
palterers11249542palterers
patterer103112182patterer
waterer103314082wa_terer
adherer1137573_adherer
adulterer1043553adulterer
alerter72111513_al_erter
aliener71011193_aliener
alleger8319633_alleger
allurer7348433_allurer
alter54828503_alt__er
alters64924223_alter_s
austerer838383austerer
bantered113313653bantered
banterers112410013banterers
bartered113113033bartered
barterers11269643barterers
battener10369403battener
battered113315073battered
batterers113110723batterers
bitterer10309783bitterer
blatherer14176723blatherer
bolsterer1145483bolsterer
cantered113415993cantered
caperer113013403ca_perer
capturer1246103capturer
careerer1038583careerer
catered103117783ca_tered
caterers102814413ca_terers
charterer14197333charterer
chatterer14196843chatterer
clatterer11186993clatterer
dapperer1335763dapperer
eagerer8248823ea_gerer
easterner945063easterner
enterer72015633_enterer
factored1436233factored
facture12108943facture_
factures13129043factures
fairer95212063fa__irer
fakeer13378743fa_ke_er
falconer1346043falconer
falderal12104803falderal
falderol12103853falderol
faller94621233fal__ler
fallers103917993faller_s
falser93912413fal__ser
faltering132211123faltering
farer86733143fa___rer
farther1348343fart_her
fastened12257853fastened
fasteners12237063fasteners
faster94625773fast__er
father125116713fa_t_her
fathered151510433fathered
fattened12268283fattened
fatteners12236883fatteners
fatter94523213fa_t_ter
fattier103513463fa_ttier
faultier1135283fault_ier
favorer1355883fa_vorer
favourer1443823favourer
festered122512113festered
fettered12259493fettered
fetterers12267043fetterers
filter94517633filt__er
filters103816553filter_s
filthier1434073filthier
fingerer12127223fingerer
flattener12175173flattener
flatter103815963flat_ter
flattered13188643flattered
flatterers13175913flatterers
flavorer1454563flavorer
fleecer12368033f_leecer
fleer86020773f_l_e_er
fleered11309503f_leered
fleeter103210363f_leeter
floorer10248073f_loorer
flowerer1435453flowerer
flutterer12185263flutterer
fostered122210453fostered
fosterers12238023fosterers
fracturer14134643fracturer
fritterer12234403fritterer
fruiterer1243333fruiterer
fullered1236383fullered
furtherer1543813furtherer
galere73716693gal_ere_
galeres83514343gal_eres
gartered10319603gartered
gatherer12147913gatherer
halter94420883halt__er
halters104619803halter_s
hammerer15278143hammerer
hamperer15379093hamperer
hankerer15248233hankerer
hastener11259143hastener
jabberer1944023jabberer
latherer111310453latherer
letterer8259223letterer
litterer82810173litterer
loiterer837083loiterer
maltier93015483malt_ier
maltster1035303maltster
mastered112614013mastered
mattered112412913mattered
maturer938983ma_turer
miterer92511333_miterer
mutterer10218913mutterer
nattered92011633nattered
oysterer1136103oysterer
palaverer1443173palaverer
palter84423263palt__er
palters94021683palter_s
paltrier1037543paltrier
pamperer14228333pamperer
panderer112210913panderer
paperer113111903pa_perer
parterre1037013parterre
pasturer1037523pasturer
pattered112714213pattered
patterers112410133patterers
peltered112510453peltered
pesterer102412713pesterer
pewterer13256313pewterer
pilferer1344923pilferer
plasterer1178113plasterer
potterer102310263potterer
poulterer1145423poulterer
putterer10209913putterer
quarterer18145723quarterer
raftered1237673raftered
rattener8238533rattener
realtered1037903realtered
salter64325083salt__er
saltern74010653salter_n
salterns8388903salterns
salters73622253salter_s
saltier74318633salt_ier
saltire73113043saltire_
saltires83112433saltires
saltpeter1153163saltpeter
saunterer945033saunterer
scatterer11186293scatterer
shatterer12177203shatterer
shelterer1245043shelterer
silverer11216733silverer
slaverer11196993slaverer
smatterer11185813smatterer
solderer947183solderer
tamperer12248893tamperer
taperer92511793ta_perer
tattered92011453tattered
titterer8268523titterer
totterer8217793totterer
unaltered1037733unaltered
utterer71910463_utterer
wagerer11328493wa_gerer
waitered1238763waitered
waltzer1934383walt_zer
wanderer122210123wanderer
watered113014963wa_tered
waterers112312793wa_terers
waterier11312103wa_terier
waverer13319523wa_verer
weltered12238443weltered
winterer112110443winterer
yammerer15225483yammerer
yattered12239543yattered

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.423422437.4
2DLD Change Limit1461621946.61022112.3
3Display Results1941940.0762552.6
 (SQL Overall)1786911947.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.