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
falterer1123985(None) 
alterer72713991_alterer
faltered122810981faltered
falterers12238031falterers
filterer11258141filterer
palterer102411271palterer
altered83215732_altered
alterers82512492_alterers
banterer102811772banterer
barterer102711632barterer
batterer102713212batterer
caterer92815942ca_terer
falter94519052falt__er
falters103916472falter_s
fastener11227832fastener
fattener11268112fattener
fetterer11207812fetterer
filtered12259042filtered
filterers12206972filterers
flatterer12187672flatterer
fosterer11239522fosterer
haltere103614702haltere_
haltered123112552haltered
halteres113414592halteres
paltered113012482paltered
palterers11249532palterers
patterer103112172patterer
waterer103314072wa_terer
adherer1137563_adherer
adulterer1043553adulterer
alerter72111513_al_erter
aliener71011193_aliener
alleger8319623_alleger
allurer7348433_allurer
alter54828503_alt__er
alters64924223_alter_s
austerer838383austerer
bantered113313633bantered
banterers112410003banterers
bartered113113013bartered
barterers11269633barterers
battener10369393battener
battered113315053battered
batterers113110713batterers
bitterer10309773bitterer
blatherer14176713blatherer
bolsterer1145483bolsterer
cantered113415983cantered
caperer113013403ca_perer
capturer1246093capturer
careerer1038583careerer
catered103117773ca_tered
caterers102814403ca_terers
charterer14197323charterer
chatterer14196843chatterer
clatterer11186983clatterer
dapperer1335763dapperer
eagerer8248823ea_gerer
easterner945053easterner
enterer72015633_enterer
factored1436213factored
facture12108923facture_
factures13129023factures
fairer95212063fa__irer
fakeer13378743fa_ke_er
falconer1346033falconer
falderal12104803falderal
falderol12103853falderol
faller94621233fal__ler
fallers103917993faller_s
falser93912413fal__ser
faltering132211113faltering
farer86733143fa___rer
farther1348343fart_her
fastened12257853fastened
fasteners12237053fasteners
faster94625773fast__er
father125116713fa_t_her
fathered151510433fathered
fattened12268283fattened
fatteners12236873fatteners
fatter94523213fa_t_ter
fattier103513463fa_ttier
faultier1135283fault_ier
favorer1355883fa_vorer
favourer1443823favourer
festered122512103festered
fettered12259493fettered
fetterers12267043fetterers
filter94517633filt__er
filters103816553filter_s
filthier1434073filthier
fingerer12127223fingerer
flattener12175173flattener
flatter103815963flat_ter
flattered13188623flattered
flatterers13175913flatterers
flavorer1454553flavorer
fleecer12368033f_leecer
fleer86020773f_l_e_er
fleered11309503f_leered
fleeter103210363f_leeter
floorer10248073f_loorer
flowerer1435453flowerer
flutterer12185263flutterer
fostered122210443fostered
fosterers12238023fosterers
fracturer14134623fracturer
fritterer12234403fritterer
fruiterer1243333fruiterer
fullered1236383fullered
furtherer1543813furtherer
galere73716673gal_ere_
galeres83514333gal_eres
gartered10319583gartered
gatherer12147903gatherer
halter94420883halt__er
halters104619803halter_s
hammerer15278143hammerer
hamperer15379093hamperer
hankerer15248233hankerer
hastener11259133hastener
jabberer1944023jabberer
latherer111310443latherer
letterer8259223letterer
litterer82810173litterer
loiterer837083loiterer
maltier93015483malt_ier
maltster1035303maltster
mastered112614003mastered
mattered112412903mattered
maturer938973ma_turer
miterer92511333_miterer
mutterer10218913mutterer
nattered92011623nattered
oysterer1136103oysterer
palaverer1443163palaverer
palter84423263palt__er
palters94021683palter_s
paltrier1037523paltrier
pamperer14228333pamperer
panderer112210913panderer
paperer113111903pa_perer
parterre1036983parterre
pasturer1037523pasturer
pattered112714203pattered
patterers112410123patterers
peltered112510443peltered
pesterer102412703pesterer
pewterer13256313pewterer
pilferer1344923pilferer
plasterer1178103plasterer
potterer102310263potterer
poulterer1145423poulterer
putterer10209913putterer
quarterer18145713quarterer
raftered1237663raftered
rattener8238533rattener
realtered1037893realtered
salter64325083salt__er
saltern74010653salter_n
salterns8388903salterns
salters73622253salter_s
saltier74318633salt_ier
saltire73113033saltire_
saltires83112423saltires
saltpeter1153163saltpeter
saunterer945033saunterer
scatterer11186293scatterer
shatterer12177203shatterer
shelterer1245033shelterer
silverer11216733silverer
slaverer11196993slaverer
smatterer11185813smatterer
solderer947183solderer
tamperer12248893tamperer
taperer92511793ta_perer
tattered92011443tattered
titterer8268523titterer
totterer8217793totterer
unaltered1037723unaltered
utterer71910463_utterer
wagerer11328493wa_gerer
waitered1238753waitered
waltzer1934383walt_zer
wanderer122210123wanderer
watered113014953wa_tered
waterers112312783wa_terers
waterier11312083wa_terier
waverer13319523wa_verer
weltered12238433weltered
winterer112110443winterer
yammerer15225483yammerer
yattered12239533yattered

Search took 9 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.1731032896.0
2DLD Change Limit1461621947.73318901.1
3Display Results1941940.0762552.6
 (SQL Overall)1786911947.98222386.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.