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

231 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
jittered1626722(None) 
bittered112711831bittered
littered92511381littered
tittered9239491tittered
battered113315052battered
bettered113011832bettered
bistered112913322bistered
bitterer10309772bitterer
buttered112712622buttered
chittered15166412chittered
cottered112511732cottered
dithered13189292dithered
fettered12259492fettered
filtered12259042filtered
flittered13196252flittered
frittered13205162frittered
gettered10258612gettered
glittered11195402glittered
guttered10259152guttered
jiggered1834202jiggered
jitter133314992jitter__
jitterier1644432jitterier
jitters144314462jitter_s
jittery17346442jitter_y
kittened1334522kittened
lettered92910782lettered
litterer82810172litterer
mattered112412902mattered
mitered103213232mi_tered
mittened1136362mittened
muttered112610792muttered
nattered92011622nattered
pattered112714202pattered
pottered112311662pottered
puttered112611142puttered
sintered92213902sintered
sistered92612802sistered
skittered1434632skittered
tattered92011442tattered
titterer8268522titterer
tottered9208702tottered
twittered1333812twittered
uttered82712432_uttered
wintered122111572wintered
withered15169432withered
yattered12239532yattered
altered83215733_altered
antlered938253antlered
attired8238913_attired
bantered113313633bantered
bartered113113013bartered
battened11259573battened
batterer102713213batterer
bickered17108003bickered
bistred103311853bist_red
bitted94418483bitt__ed
bitter84622673bitter__
bitterest1147713bitterest
bitterly1335603bitterly
bittern94810683bitter_n
bitterns10428943bitterns
bitters94920353bitter_s
bitterweed1642753bitterweed
blattered12198563blattered
blistered12167683blistered
blithered15156123blithered
bothered142110393bothered
cantered113415983cantered
catered103117763_catered
centered112513523centered
chattered15197983chattered
cindered1239793cindered
ciphered1637053ciphered
cittern9339133citter_n
citterns10318113citterns
clattered12178403clattered
cluttered12185933cluttered
cratered1149673cratered
diapered1238003diapered
dickered16117533dickered
differed1635523differed
ditherer12187763ditherer
dittoed936733ditt_oed
dotterel945063dotterel
embittered1542543embittered
entered82718883_entered
faltered122810983faltered
fathered151510433fathered
fattened12268283fattened
festered122512103festered
fetterer11207813fetterer
fibered1337643fi_bered
filterer11258143filterer
fingered13128333fingered
fitted104716663fitt__ed
fitter94120033fitter__
fitters104517743fitter_s
flattered13188623flattered
fluttered13185943fluttered
fostered122210443fostered
fritterer12234403fritterer
gartered10319583gartered
gathered13149373gathered
gibbered1444303gibbered
gingered11127743gingered
gitted84015053gitt__ed
gittern8337503gitter_n
gitterns9326563gitterns
glistered11176293glistered
haltered123112553haltered
hindered1339453hindered
hitter94419863hitter__
hitters104717583hitter_s
imbittered1542083imbittered
inhered11313163_inhered
interbed112413103_interbed
interned93016653_interned
interred92615263_interred
itemed936603_i_temed
jabbered2034433jabbered
jeered143912793j__eered
jetted143915083jett__ed
jettied15366973jett_ied
jilted144111353jilt__ed
jilter133512513jilter__
jilters144211953jilter_s
jitterbug1941703jitterbug
jitteriest1744553jitteriest
jittering17218413jittering
jointured17133483jointured
jotted143615173jott__ed
jotter134315633jotter__
jotters143413803jotter_s
juddered1833583juddered
jutted144315023jutt__ed
juttied15417863jutt_ied
kippered17255623kippered
kitted115114833kitt__ed
kittled12388193kitt_led
lathered121512323lathered
leistered1037043leistered
letterer8259223letterer
lightered1446273lightered
limbered13158123limbered
lingered10129643lingered
lippered13287953lippered
listened9168813listened
litter64324853litter__
litterers9228193litterers
litters73422563litter_s
littery103710493litter_y
livered113111633li_vered
loitered938183loitered
lustered92510603lustered
mastered112614003mastered
metered103514013_metered
mistermed1438363mistermed
miterer92511333mi_terer
mitred94414343mi_t_red
mothered142310103mothered
mustered112511503mustered
mutterer10218913mutterer
neutered937423neutered
nickered15117023nickered
niffered1544143niffered
oystered1236913oystered
paltered113012483paltered
pattened11299393pattened
patterer103112173patterer
patterned1265743patterned
peltered112510443peltered
pestered112814953pestered
petered103314963_petered
philtered1545493philtered
pictured1346573pictured
pilfered1435853pilfered
pitted94319593pitt__ed
portered112311533portered
pothered142311043pothered
potterer102310263potterer
putterer10209913putterer
raftered1237663raftered
rattened9218623rattened
reuttered1036073reuttered
ritter63822413ritter__
ritters74020613ritter_s
roistered1037633roistered
scattered12197353scattered
scuttered12166423scuttered
shattered13178203shattered
shuttered13156333shuttered
silvered12237563silvered
simmered1336863simmered
simpered1338253simpered
sitter63323383sitter__
sitters74221543sitter_s
slithered13136623slithered
smattered12186783smattered
spattered12187643spattered
sputtered12166323sputtered
steered83615253_steered
stuttered10145763stuttered
swithered16135463swithered
teetered9258303teetered
tentered96412103tentered
tethered1238493tethered
tiered73613973__tiered
tillered937433tillered
timbered13137383timbered
tinkered1387683tinkered
titter63421163titter__
titterers9236993titterers
titters74219613titter_s
tittuped1142063tittuped
totterer8217793totterer
twitterer1243303twitterer
unuttered1065733unuttered
utterer71910463_utterer
vittled11347343vitt_led
waitered1238753waitered
watered113014953_watered
weltered12238433weltered
westered122511863westered
wildered1336633wildered
winterer112110443winterer
winterfed1644993winterfed
witherer14187953witherer
witherod15156153witherod
witted104216813witt__ed
wuthered15157433wuthered
zippered22244823zippered

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.1731032896.0
2DLD Change Limit1461622316.98320931.1
3Display Results2312310.0932483.9
 (SQL Overall)1786912317.24924650.4
 
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.