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

240 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
litterer8281017(None) 
bitterer10309781bitterer
letterer8259221letterer
littered92511381littered
litterers9228191litterers
titterer8268531titterer
batterer102713222batterer
bittered112711832bittered
clatterer11186992clatterer
ditherer12187762ditherer
fetterer11207812fetterer
filterer11258142filterer
flatterer12187682flatterer
flittered13196252flittered
flutterer12185262flutterer
fritterer12234412fritterer
glittered11195412glittered
jittered16267222jittered
jitterier1644442jitterier
latherer111310452latherer
lettered92910782lettered
letterers9228112letterers
limberer12187052limberer
lingerer9118302lingerer
listener8158312listener
litter64324852litt__er
litters73422572litter_s
littery103710492litter_y
littler7348552litt_ler
loiterer837082loiterer
miterer92511332mi_terer
mutterer10218912mutterer
patterer103112182patterer
potterer102310262potterer
putterer10209912putterer
tittered9239502tittered
titterers9236992titterers
totterer8217792totterer
twitterer1243312twitterer
utterer71910462_utterer
winterer112110442winterer
witherer14187952witherer
alterer72714013_alterer
austerer838383austerer
banterer102811783banterer
barterer102711653barterer
battener10369403battener
battered113315073battered
batterers113110723batterers
bettered113011843bettered
bickerer16106783bickerer
bistered112913333bistered
bitter84622673bitt__er
bitterest1147713bitterest
bitterly1335603bitterly
bittern94810683bitter_n
bitterns10428953bitterns
bitters94920363bitter_s
bittier94211663bitt_ier
blatherer14176723blatherer
blattered12198583blattered
blistered12167683blistered
blithered15156123blithered
blusterer11176293blusterer
buttered112712633buttered
butterier1177463butterier
caterer92815953_caterer
chatterer14196843chatterer
chittered15166413chittered
cipherer1545573cipherer
cittern9339143citter_n
citterns10318123citterns
clattered12178423clattered
clatterers12155423clatterers
cluttered12185943cluttered
cottered112511743cottered
dithered13189293dithered
ditherers13196683ditherers
dotterel945063dotterel
enterer72015633_enterer
falterer11239873falterer
fattener11268113fattener
fettered12259493fettered
fetterers12267043fetterers
filtered12259043filtered
filterers12206973filterers
fingerer12127223fingerer
fitter94120033fitt__er
fitters104517753fitter_s
flattener12175173flattener
flattered13188643flattered
flatterers13175913flatterers
flitter103413903flitt__er
flitters114312173flitter_s
fluttered13185943fluttered
flutterers13184593flutterers
fosterer11239523fosterer
frittered13205173frittered
fritterers13203393fritterers
gatherer12147913gatherer
gettered10258613gettered
gittern8337503gitter_n
gitterns9326573gitterns
glistered11176303glistered
glitter84211803glitt__er
glitters93710543glitter_s
glittery12375613glitter_y
guttered10259173guttered
hinderer1238273hinderer
hitter94419863hitt__er
hitters104717593hitter_s
integer837993_integer
jitter133314993jitt__er
jitters144314473jitter_s
jittery17346443jitter_y
kipperer16294723kipperer
kittened1334533kittened
kittler11338163kitt_ler
lateener835763lateener
lathered121512333lathered
latherers12158853latherers
latter65027893latt__er
latterly1136063latterly
lecturer10136033lecturer
leistered1037043leistered
letter63722583lett__er
lettermen1164283lettermen
letters73819853letter_s
libeler9219003li_beler
lieder74912323li__eder
liefer9529573li__efer
liever94611863li__ever
lifter93814813lift__er
lifters104313783lifter_s
lightener1345693lightener
lightered1446283lightered
limbered13158123limbered
lingered10129643lingered
lingerers10126923lingerers
linter64625343lint__er
linters73822633linter_s
lintier73613803lint_ier
lippered13287953lippered
listee64223063liste_e_
listees73416673liste_es
listened9168813listened
listeners9147333listeners
lister64527253list__er
listeria839453listeria
listers74026533lister_s
liter54736343li_t__er
literal7613273li_teral
literary1147753li_terary
liters65429883li_ter_s
lither94520953li_t_her
litre55421463li_t_re_
litres65220393li_t_res
litten64014873litt__en
litterateur1151463litterateur
litterbag1242793litterbag
litterbug1242393litterbug
littering102411983littering
little63312163litt_le_
littles73212783litt_les
littoral845273littoral
livener10278943li_vener
livered113111633li_vered
lobsterer1144033lobsterer
loitered938183loitered
loiterers936263loiterers
lotter64025603lott__er
lotteries9311083lotteries
lotters73921063lotter_s
lottery10389833lotter_y
lumberer12177583lumberer
lustered92510613lustered
mattered112412913mattered
mitered103213233mi_tered
miterers10219683mi_terers
mittened1136373mittened
muttered112610803muttered
mutterers11247373mutterers
nattered92011633nattered
nittier73512243nitt_ier
oysterer1136103oysterer
palterer102411293palterer
pattered112714213pattered
patterers112410133patterers
pesterer102412713pesterer
pewterer13256313pewterer
pilferer1344923pilferer
plasterer1178113plasterer
pottered112311663pottered
potterers11218663potterers
puttered112611153puttered
putterers11238363putterers
rattener8238543rattener
ritter63822423ritt__er
ritters74020623ritter_s
roisterer946433roisterer
rottener8216983rottener
scatterer11186293scatterer
shatterer12177203shatterer
silverer11216733silverer
simperer1237173simperer
sincerer1037203sincerer
sintered92213903sintered
sistered92612803sistered
sitter63323383sitt__er
sitters74221553sitter_s
skittered1434633skittered
skitterier1442423skitterier
slithered13136623slithered
slitter73615873slitt__er
slitters84014133slitter_s
slittier837003slitt_ier
sliverer11237633sli_verer
smatterer11185813smatterer
splutterer12132743splutterer
sputterer11165263sputterer
steerer73113633_steerer
stutterer9164913stutterer
tattered92011453tattered
tinkerer1286803tinkerer
titter63421163titt__er
titters74219623titter_s
tottered9208703tottered
totterers9186813totterers
twittered1333823twittered
twitterers1342673twitterers
uttered82712443_uttered
utterers8218653_utterers
waterer103314083_waterer
wintered122111573wintered
winterers12209723winterers
winterier1238343winterier
withered15169433withered
witherers15146843witherers
wittier103910823witt_ier
yattered12239543yattered

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.453394461.4
2DLD Change Limit1461622408.26617682.3
3Display Results2402400.0932580.6
 (SQL Overall)1786912408.81220278.1
 
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.